Re: tg4msql Connection Problem

Ronald Ferro via DBMonster.com wrote:

> Here is the message:
> ERROR at line 1:
> ORA-28500: connection from ORACLE to a non-Oracle system returned this
> message:
> [Transparent gateway for MSSQL][Microsoft][ODBC SQL Server Driver][DBNETLIB]
> SQL
> Server does not exist or access denied. (SQL State: 08001; SQL Code: 17)
> ORA-02063: preceding 2 lines from TG4MSQL

That would seem to be related to a configuration error on the Gateway, or an invalid authentication string used for the database link. The actual error is a dblib error - not an Oracle error. So the Gateway's calls to dblib worked.. simply that those dblib calls returned errors because they were not happy with the contents of the parameters.

The real juicy (or crunchy if that's your choice) data that you have not posted is the trace files of the Gateway.

You can also turn on debug tracing on the Gateway - which is likely the single most useful thing to do when dealing with problems like the above. It shows step by step the calls made by the Gateway to the foreign database - including the authentication

    part.

--
Billy