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?
我已经使用Oracle提供程序oledb在Sql Server 2005上设置了Oracle链接服务器,并且从sql server 2005到oracle 9i工作正常,即当我从sql server运行分布式查询时,我从oracle服务器获取数据到sql server。现在我没有任何线索如何从Oracle服务器运行分布式查询并重复从sql server获取数据。我必须设置Dsn吗?在从oracle服务器运行查询之前我还需要设置什么?
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)
仅供参考:Oracle服务器是Sun solaris服务器,SQL服务器是x64 Windows Server 2003.Sql server上安装了oracle客户端,其中包含ORACLE Provider for OLEDB的odac驱动程序。我将使用loadjava将java加载到oracle中,然后重复地在两者之间移动数据。 (来自oracle的Java,存储过程和触发器,用于从sql server获取数据)
2 个解决方案
#2
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.
链接数据库是第一阶段。之后,您可能会面临我们遇到的问题,例如无法远程将从Sql Server中提取的行删除到Oracle Server。我将发布一个问题,奇怪的是我们用于数据同步的程序不会相同。
#1
#2
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.
链接数据库是第一阶段。之后,您可能会面临我们遇到的问题,例如无法远程将从Sql Server中提取的行删除到Oracle Server。我将发布一个问题,奇怪的是我们用于数据同步的程序不会相同。