Re: Connecting Oracle 9iR2 (9.2.0.2) to Oracle 7.3.4 via Heterogenous Services

All,

After more experimentation, I was able to get this configuration working as follows:

Platform: Windows XP Professional
Server Version : 9.2.0.2 in OraHome92 D:\Oracle\Ora92 Client Version : 8.1.7.4 in OraHome81 D:\Oracle\Ora81 ODBC Driver: Microsoft ODBC Driver for Oracle

Its a little slower than a traditional db_link but it works!

rcarden_at_email.usps.gov (R. Carden) wrote in message news:<7cfd8288.0303060939.78139b2c_at_posting.google.com>...
> Hello!
>
> I need to connect an Oracle 9iR2 database to an embedded Oracle 7.3.4
> database. I have discovered (as have many unhappy Oracle customers)
> that you can't connect directly from an 9iR2 database to a 7.3.4
> database.
>
> As a work around, I am trying to use the Heterogenous Services Generic
> Connectivity feature through ODBC to connect to the 7.3.4 database.
>
> I have a test machine with the Oracle 9iR2 server installed on it
> along with the Oracle 8.1.7.4 client and ODBC driver.
>
> I have set up an ODBC DSN for the 7.3.4 database using the 8.1.7.4
> driver and can link to this database from the server with MS Access.
>
> I then set up a dblink using generic connectivity and getting am
> getting an ORA-02068 error.
>
> Has anyone tried this solution and been able to make it work? Any
> help or advice would be appreciated.
>
> Thanks,
>
> Roger
Received on Fri Mar 07 2003 - 11:26:08 CST