Monday, March 12, 2012

Oracle Server connecting to a Microsoft SQL Server

Hello everyone,
I am new to this so I need a lot of help. We have an
Oracle server. From the server I need to connect to a
Microsoft SQL Server. We can currently connect to other
Oracle servers by creating a Database Link. We used
Oracle Enterprise Manager to create the database links
and updated the TNSNAMES.ora file on the server. By
trying to do the same thing for the SQL server, we are
unsuccessful. Could someone please help us? Please
remember we are new to this process.
Thank you!Read the section 'Managing Clients' under 'Administering
SQL Server' in the SQL2000 Books Online.
Linchi
quote:

>--Original Message--
>Hello everyone,
>I am new to this so I need a lot of help. We have an
>Oracle server. From the server I need to connect to a
>Microsoft SQL Server. We can currently connect to other
>Oracle servers by creating a Database Link. We used
>Oracle Enterprise Manager to create the database links
>and updated the TNSNAMES.ora file on the server. By
>trying to do the same thing for the SQL server, we are
>unsuccessful. Could someone please help us? Please
>remember we are new to this process.
>Thank you!
>.
>

No comments:

Post a Comment