Oracle Database Discussions

Hi all,

I need to connect from Oracle to SQL Server through DB-LINK, and since my Oracle installation does not contain HSODBC, I installed DG4ODBC.

My actual SW configuration is:

1) Oracle Server (64-bit):
OS: Windows Server 2008 Standard SP2
DB: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
Gateway: Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with Oracle Database Gateway for ODBC
Oracle Home: E:\oracle\product\10.2.0\db_1\
Gateway Home: D:\apps\product\11.2.0\tg_1\
Also, there is running an ArcGIS/ArcSDE 10.0 over Oracle.

2) MS SQL Server (32-bit):
OS: Windows NT 5.2 SP2
DB: Microsoft SQL Server 2000 - 8.00.2065 (Intel X86)

There are two listeners running (one of each installation, 10.2 and 11.2) which, I suppose, can cause conflicts or reduce performance. As a restriction, I need the listener 10.2 to continue

running unchanged since ArcSDE services use it and re-create them is a pain.

So my question is, how I can configure one (10.2) or both listeners (10.2 and 11.2) to use DG4ODBC to connect to a remote SQL Server from Oracle?

I have followed several threads from this forum, trying different configurations but I cannot connect successfully with the DATABASE LINK. In most case I get ORA-28545 and ORA-02063 errors.

Can anyone help me resolve this problem? Do I need to send more information, e.g. init {SID}. now, listener.ora, tnsnames.ora, etc. for clarification?

Thank you very much beforehand.

Gaston.