March 9, 2004 at 3:13 pm
I'm trying to set up a linked server connection between a SQL Server 7.0 db & an Oracle 8.i instance.
I can ping the oracle server & db from the SQL Server box and I can logon to the Oracle db (using sqlplus) from the server where I'm running SQL Server so I know the boxes can talk and I'm using the right Oracle logon and password.
I created the linked server conection by running this ddl in QA:
exec sp_addlinkedserver 'CNRDAPRD', 'Oracle', 'MSDAORA', 'cnrdaprd'
followed by:
exec sp_addlinkesrvlogon 'CNRDAPRD', 'false', 'local SQL Server logon', 'ORA logon', 'ORA password'
When I go into SEM & try to expand the tables under the linked server connection icon I get the following message:
Error: 7399: OLE DB Provider 'MSDAORA'
reported an error.
Can't figure out what's causing this error. Any hep greatly appreciated. Thanks in advance.
March 9, 2004 at 4:52 pm
Did you mean sp_addlinkedsrvlogin
Try
sp_addlinkedsrvlogin 'CNRDAPRD', 'false', null, 'ORA logon', 'ORA password'
March 10, 2004 at 6:35 am
sorry, that was a typo on my part i did use the sp_addlinkedsrvlogin proc and my linked server login is added correctly
March 10, 2004 at 11:13 am
We checked the Oracle Client software registry entries on the client (SQL Server) computer. We found the registry
entries pointing to Oracle Client 7.3 dlls even though those dlls are not installed on the server. Oracle Client 8.i is installed on the server & those were the dlls we expected to see in the registry. Somehow the regidtry entries got corrupted or overlaid. We scheduled an emergency reboot of the server and when the server came back up we were able to query and retrieve data from our remote server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply