May 18, 2006 at 8:49 am
Hi,
I'm using sql server 2000 installed on a win 2k machine. I configured an oracle linked server and able to access data in the oracle database. Now the problem is, "the same" does work on sql server 2000 installed on a win 2003 machine. please help me..
I get following error when i configure linked server on windows 2003 machine
Error 7399: OLE DB provider 'MSDAORA'reported an error.
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDIntialize::Intialize returned 0x80004005: ].
It was working well on windows 2000 machine but not on windows 2003. Please help...
Thanks
May 22, 2006 at 6:43 am
If you are using ORA92 SQL-NET trythis:
Look for a file named sqlnet.ora
look for the line:
SQLNET.AUTHENTICATION_SERVICES =(****)
forgot what the default is but change
**** to NONE
in other words make it look like the line below:
SQLNET.AUTHENTICATION_SERVICES =(NONE)
I had the same problem and this fixed it - maybe it will work for you
May 22, 2006 at 11:27 pm
I changed sqlnet.ora file as you specified, but it's of no use.. i'm facing with same problem...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply