0

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)

2 Answers2

0

linking databases is the first phase. After that you may face the problems we faced, like not being able to delete fetched rows from Sql Server to Oracle Server remotely. I will post a question about that, it is odd that our procedures used for data synching do not respons the same.

kayhan yüksel
  • 378
  • 2
  • 9
  • 24
0

Here is one way. DG4ODBC setup guide here.

This might help, too.

DCookie
  • 42,630
  • 11
  • 83
  • 92