Oracle - SQL Server database link

From: Pam Knight <knightp_at_wharton.upenn.edu>
Date: Sun, 12 Oct 2003 16:21:06 -0400
Message-ID: <bmcd3j$106h$1@netnews.upenn.edu>

Is anyone working with databases on both Oracle and SQL Server and using an Oracle database link to successfully query a SQL Server database? The Oracle database is running under AIX.

It looks like the Oracle is working fine - database link is established - but the response to querying the SQL Server database is

ORA-12537: TNS:connection closed

This appears to me to be possibly a situation where the SQL Server is not 'trusting' the Oracle machine to query its database.

I have checked to make sure that the port numbers on both sides are the same (when differnet, the error message from Oracle was something to the effect of NO Listener running). So I believe that connectivity has been established.

Any information will be greatly appreciated. Received on Sun Oct 12 2003 - 15:21:06 CDT