SQL linked server to Oracle

[khuehne]

I am trying to set up a linked server to Oracle in SQL 2000 server. I set it up on my local instance of SQL and it worked fine. On our production SQL Server, I get the following error: Error 7399 OLEDB Provider MSDAORA reported an error. When I trace it in Profiler, I get the following information: OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005:. The production box is running Windows 2000, MDAC 2.7. Any suggestions are appreciated!

 

[ecobb]

Check the basics:

1) Do you have Oracle Client Tools installed on the SQL Server?

2) Have you added the appropriate registry keys to the server's registry?

3) Does the username/password you're using for the linked server have sufficient permissions on the Oracle Database?

4) In your sqlnet.ora file, make sure that "SQLNET.AUTHENTICATION_SERVICES= (NONE)" (it's set to "NTS" by default, I think) for this datasource.

I just went through this myself a few weeks ago. Here's a couple of articles I found that really helped me out.

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=22264

http://www.databasejournal.com/features/mssql/article.php/10894_1756161_3

Here's a link to my thread with the problems I encountered and what I wound up doing to fix it.
thread962-697079




Hope This Helps!

Ecobb

"Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer." - Homer Simpson

 

[khuehne]

I ended up removing and re-installing the Oracle client tools and it worked. Thanks for your help!