Linking to an Oracle Database on another Server

[DanAuber]

Can anyone help. I want to see Oracle Tables on another server from within my SQL Server application/database. I think I can do this with Linked Server but am unsure how to configure it. I do have an ODBC link to the Oracle Database that works and an SQLnet Database Alias and I know the IP address - I just don;t know how to link all this together.....and where to put it in SQL Server Linked Server.

Thanks for any help

Dan

Dan Auber

 

[ecobb]

I did this about a year ago. Here are some articles that really helped me.

http://support.microsoft.com/default.aspx?scid=kb;en-us;280106&Product=sql2k

http://www.windowsitpro.com/SQLServer/Article/ArticleID/22264/22264.html

http://www.databasejournal.com/features/mssql/article.php/10894_1756161_3

Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[dbomrrsm]

Try DTS - add an oracle connection and supply the connection properties as prompted and you can see the Oracle DB and pull what you want into SQL Server.

[blue]DBomrrsm[/blue]