Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9i to UDB using Generic Conectivity

RE: 9i to UDB using Generic Conectivity

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 27 Aug 2004 11:54:59 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DEA4@usahm018.exmi01.exch.eds.com>


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



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Aug 27 2004 - 12:12:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US