Moving data between oracle and sql server using Linked server

Question

Hello Everyone,

I have set up Oracle Linked server on Sql Server 2005 box using Oracle provider oledb and its working fine from sql server 2005 to oracle 9i, i.e. When i run distributed query from sql server i get data from oracle server to sql server. Now I don't have any clue how do i run distributed query from Oracle server and get data from sql server repeatedly. Do i have to set up Dsn ? What other things i have to set up before i run query from oracle server?

FYI : Oracle server is Sun solaris server and SQL server is x64 Windows Server 2003. Sql server has oracle client installed on it with odac drivers for ORACLE Provider for OLEDB. I am going to use loadjava to load java into oracle and than move data between both repeatedly. (Java, Stored procedures & Triggers from oracle to get data from sql server)

Answer 1

Here is one way. DG4ODBC setup guide here.

This might help, too.

Answer 2

According to You : You have set up Oracle Linked server on Sql Server 2005 box using Oracle provider oledb and its working fine from sql server 2005 to oracle 9i, i.e. When you run distributed query from sql server you get data from oracle server to sql server.

May i know what's process you have done for this Connectivity.

Please guide me your process, point by point.

I have sql 2005, oracle 10g and server2003 (OS)