June 13, 2002 at 2:54 am
I have a problem to connect to a Oracle server.
I need to write into Two servers (SQL and Oracle) by a Distributed Query.
I tried connecting to the the oracle server after executing the below.The server gets registered.
sp_addlinkedserver 'HMS252','Oracle','MSDAORA','HISPAMS'
sp_addlinkedsrvlogin 'HMS252',false,'sa','scott','tiger'
When I click on the tables on the Linked sever I get a error message
"Error 7339: OLE DB provider 'MSDAORA' reported error"
I there any problem , can this be sorted
Mouli
June 13, 2002 at 3:18 am
sqlnet setup properly on the server? and if its working via sqlplus to the oracle box then you shouldnt have a problem, the problem may be simply with your config of the linked server, try the GUI rather than the command line to better visualise what your doing. Remember to use the SID as per the sqlnet entry. Ill post my .ora files etc and how they relate to the linked server when i eventually get home..
also, what version of oracle?
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
June 13, 2002 at 4:21 am
Thanks for the immediate reply.
Oracle : 8.1.7
The problem is sorted . There are three DLL which needs to be registered on the system where Oracle client is installed.I got the article form Microsoft Product Support.
Any way Please send me the article to my mail id chandra_li@hotmail.com or rchandra_mouli@yahoo.com
Mouli
June 30, 2002 at 7:31 am
Hi
Please post the MS article URL for reference..
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply