1 Reply Latest reply on Feb 15, 2013 10:14 AM by Chanchal Wankhade

    Unable to select from Oracle to SQL Server

      Hi group,

      I am having some issues while trying to select a SQL Server table from Oracle.

      Oracle version is 64 bits on Solaris 64 bits too, this database connects to Oracle Client (with dg4odbc) on Windows 64 bits installation (Oracle Cient version is, and finally SQL Server is running right on a Windows 2000 server on 32 bits.

      When I try to select the SQL Server table from Oracle, I am getting the next error message:

      SQL> select * from "interfaceinventarios"@TEST;
      select * from "interfaceinventarios"@TEST
      ERROR at line 1:
      ORA-28545: error diagnosed by Net8 when connecting to an agent
      Unable to retrieve text of NETWORK/NCR message 65535
      ORA-02063: preceding 2 lines from TEST

      tnsping TEST is working well.

      On the Windows Server (64 bits) I used: C:\Windows\System32\odbcad.exe executable to create the datasource.

      Any help or advice will be really appreciated.

      Thanks in advance.

      Kind regards,