Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL DB Linked Server

Author  Topic 

Faris2100
Starting Member

10 Posts

Posted - 2007-06-11 : 13:40:22
I have a linked server in SQL server 2000 that connects to ORACLE database and run a dist. query. the linked server works but occeasionally i get the error messgae ..

"Error 7399: OLE DB Provider 'MSDAORA' reported an error. The provider did not give any information about the error. OLE DB error trace.."

THE PROBLEM is resolved one i reboot the server. Any idea on what it is and how i can get rid of this problem

Thanks A lot..

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-11 : 18:00:02
Usually caused by link related issue, like network problem or status changed on oracle.
Go to Top of Page
   

- Advertisement -