Re: Oracle - SQL Server database link

You did not describe you underlying configuration.

Oracle to SQL Server can be accomplished as follows. I am sure there are other ways.

1.Requires Oracle Transparent Gateway for SQL Server- Separate product
2. ODBC drivers on your UNIX Server plus HS would allow it also.

SQL to Oracle -

1. DTS
2. Linked Servers using OLEDB..

On Sun, 12 Oct 2003 16:21:06 -0400, "Pam Knight" <knightp_at_wharton.upenn.edu> wrote:

>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 - 16:21:36 CDT