View Single Post
 
Old December 3rd, 2009, 05:16 AM
joefawcett's Avatar
joefawcett joefawcett is offline
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

You should be able to set up the Oracle instance as a linked server on the SQL Server machine, providing you have the Oracle connectivity tools installed. Alternatively take a look at the OPENQUERY function in SQL Server whereby the connection details are passed as part of the query.

Alternatively you can use Oracle to connect to SQL Server: http://www.databasejournal.com/featu...SQL-Server.htm although it's more hassle in my opinion.
__________________
Joe
http://joe.fawcett.name/