Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting from Oracle to SQL Server

781817Jun 28 2010 — edited Jun 28 2010

We have a Oracle 10gR2 on Sun Solaris 10 . And a SQl Server 2005 on a Windows 2008 box. I am trying to connect from the Oracle database to the sql server database. Installed the Oracle 11g Gateway Drivers ( Not the client , just the gateway drivers) on the Windows box. Created a DSN and started the listener on the windows. On the Oracle end , configured the tns . And I am able to ping the SQL Server from the Oracle box.
Created a database link on the oracle database. But I am unable to query the data from the sql server database.

Not sure if I am missing anything.

I have followed the below the links to configure :

http://www.databasejournal.com/features/oracle/article.php/10893_3442661_2/Making-a-Connection-from-Oracle-to-SQL-Server.htm

http://www.nixblog.org/post/2008/05/18/Installing-and-configuring-Oracle-Heterogenous-Services-for-SQLServer

Any help would be great.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 26 2010

Added on Jun 28 2010

#general-database-discussions

7 comments

1,116 views