How To Connect Oracle DB with Microsoft SQL Server

Hello,
Does anyone know how to connect Oracle 10g DB to Microsoft SQL Server? If so, any tips or help would be greatly appreciated!
Thanks!I'm not sure which side you're connecting from (from mssql to oracle or vice versa), but a good starting point would be to look up linked servers in books online. MSHelp has a pretty good troubleshooter at http://support.microsoft.com/kb/280106/ .

Good luck.|||Hello,

Does anyone know how to connect Oracle 10g DB to Microsoft SQL Server? If so, any tips or help would be greatly appreciated!

Thanks!

Things that I have done/would do in your place (not saying that they are right):

1. Install Oracle 10g Client s/w on db server
2. Create tnsnames entry(ies) using Oracle Net Manager

Then, optionally:
3a. Create a linked server and access Oracle through OPENQUERY and/or four-part naming convention
3b. Create DTS package(s) to move data local to SQL Database

Which path you choose (a or b) depends on your requirements and resources.

Regards,

hmscottsql