ODBC dblink ORA-28545: error diagnosed by Net8 when connecting to an agent
I have two servers:
- server A that is running 10g XE in Windows 7 64bit
- server B that is running SQL Server 2008 on Win Server 2003 32bit
Server A has an ODBC connection to Server B. The connection has been tested from the ODBC administrator screen and passes.
Server A has the TNSNAMES.ORA, LISTENER.ORA, and initMYSQLSERVER.ORA files configured to make the link. The listener starts up fine and the creation of the link happens without error (the user name and password defined in the link are the same as used for the ODBC configuration) but when I go to run a query I get the following error:
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 MYSQLSERVERLINK
+28545. 0000 - "error diagnosed by Net8 when connecting to an agent"+
*Cause: An attempt to call an external procedure or to issue SQL+
to a non-Oracle system on a Heterogeneous Services database link
failed at connection initialization. The error diagnosed
by Net8 NCR software is reported separately.
*Action: Refer to the Net8 NCRO error message. If this isn't clear,+
check connection administrative setup in tnsnames.ora
and listener.ora for the service associated with the
Heterogeneous Services database link being used, or with
+'extproc_connection_data' for an external procedure call.+
Error at Line: 1 Column: 27
I have been trying to find on the web any description of what is happening here and cannot seem to find anything that applies. Can anyone help me with this?