1 Reply Latest reply: Feb 15, 2013 4:14 AM by Chanchal Wankhade RSS

    Unable to select from Oracle to SQL Server

    user11985838
      Hi group,

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

      Oracle version is 10.2.0.4 64 bits on Solaris 64 bits too, this database connects to Oracle Client (with dg4odbc) on Windows 64 bits installation (Oracle Cient version is 11.2.0.1), 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,

      Francisco