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 22.214.171.124), 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.