Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9i to UDB using Generic Conectivity
At one time I had heterogeneous services set up and working for accessing
SQL Server from Oracle on AIX without any problems using an ODBC driver
obtained from Data Direct. I believe from something I read on metalink that
this feature is broke on AIX with Oracle version 9.2.0.5. You might want to
check metalink.
Development determined they wanted to use a java routine to connect to both SQL Server and Oracle.
Check metalink articles 124943.1 Problems with locating Heterogenous
Services Product on UNIX
115098.1 QUICK START GUIDE: UNIX - Generic Connectivity using ODBC
Good luck
-- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of sundeep maini
Sent: Friday, August 27, 2004 10:41 AM
To: oracle-l_at_freelists.org
Subject: 9i to UDB using Generic Conectivity
We are looking to pull some data (batch jobs no distributed OLTP) from a SAP/UDB on AIX into our 9i DB on AIX. We do have a gateway to mainframe DB2 but not to the UDB on AIX. The Hetrogeneous Services Admin guide seems to explain how to get the Generic connectivity set up.
Is anyone on the list using this kind of connectivity? Can you please share you experience with performance and set up bottlenecks? Also, which vendor's ODBC drivers are you using? I would greatly appreciate if you can list the s/w components involved in the end to end connectivity and what features you had difficulty using or any SQL caveats you learnt by using this architecture.
This is to avoid using FTP and synchronized push and pull at the two ends. However any suggestions are welcom.....
TIA
Sundeep
Sundeep Maini
Consultant
Currently on Assignement at Caterpillar Peoria
sundeep_maini_k_at_cat.com
![]() |
![]() |