Paul, Here is a document on how to configure Easysoft for UniVerse. In fact, It was first installed for UniVerse then UniData. "Accessing ODBC Databases from IBM UniVerse/UniData"
http://www.easysoft.com/applications/ibm-universe-unidata/odbc.html You Can do a search on their website. Also, Here is a "Success story" on the U2UG website. See link and story below: Using the EasySoft ODBC-ODBC Bridge product, we are able to establish two-way connectivity between our Universe and Oracle databases. http://www.u2ug.org/index.php?module=pnForum&func=viewtopic&topic=127 Posted: 03.08.2004, 15:29 We have just successfully connected our Universe database with our Oracle database using Easysoft's ODBC-ODBC Bridge. To sum up what we have accomplished, so that we can add to your knowledge base: The requirement is to enable an ODBC connection between Universe and Oracle, both of which run on Unix. Either database must be able to initiate a transaction, i.e. Universe can connect to Oracle and Oracle can connect to Universe. We tried the Data Direct ODBC client for Unix to tie Universe to Oracle, but it served only the Universe BCI call to Oracle. It did not satisfy the need to connect to Universe from Oracle using Oracle's Heterogenous Gateway. Since Universe does not have an ODBC client that runs on Unix, we have to bounce the ODBC call from our Oracle database to an NT/2000 server in order to access the Universe ODBC client. EasySoft, in England, has a product they call an ODBC-ODBC Bridge. This is composed of an OOB server, which in our case runs on an NT/2000 box, and an OOB client, which can run from Windows, Unix or Linux. When an ODBC call is issued from the database, the OOB client on the local server calls the OOB server on the NT/2000 box, which then redirects the call to the ODBC client running on the NT/2000 server, which then proceeds to connect to the target database. Using the EasySoft ODBC-ODBC Bridge product, we are able to establish two-way connectivity between our Universe and Oracle databases. Licensing for the Easysoft ODBC-ODBC Bridge is based on the server. You can have as many clients as needed. They have a per server license plan, or you can get a site license if you need to have 4 or more servers on the same site. 8-) Hope this helps. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Janet Bond Sent: Tuesday, October 31, 2006 8:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] ODBC connections [ad] Hi Paul, If you would like to call me I can get you connected with one of the developers to discuss your options. Janet FusionWare Corporation Sales Operation Manager 1.800.266.2326 x1159 [ad] ________________________________ From: [EMAIL PROTECTED] on behalf of I-Rafferty, Paul Sent: Tue 10/31/2006 1:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] ODBC connections Thanks for the updates. Unfortunately Easysoft do not sell odbc drivers for Universe. We have decided to use one of the Oracle databases on Windows as a gateway to the Universe database. It seems to be the easiest way at this stage. Thanks again. Paul. -----Original Message----- From: Adrian Merrall [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 October 2006 10:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] ODBC connections > Also on your Universe on HPUX via odbc you will need an HPUX driver > either > 32 or 64 bit. You can get this from http://www.easysoft.com <http://www.easysoft.com/> I think from reading the OP Paul needs a Linux ODBC client that can speak to Universe on HPUX. If IBM only provide a windows based odbc client for Universe then he might have a problem here. A solution may be to use the JDBC driver provided by IBM as Janet suggested but use a odbc-jdbc bridge so the Oracle client can use ODBC. A quick google shows one from easysoft and one from Sun as part of the java stack. Plan B is to talk directly to the Universe jdbc driver of course but if you are going to be writing java code then consensus on the list is usually to use uniobjects directly. HTH Adrian ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
