Post reply

Configuring linked server on windows 2003

  • May 18, 2006 at 8:44 am

    #67489

    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 19, 2006 at 7:54 am

    #638986

    We have the same setup and it is working. Do you have all the oracle components installed? Also do you have the tnsnames.ora and sqlnet.ora configured to the same as the windows 2K box?

  • May 19, 2006 at 8:03 am

    #638998

    Yes, i have checked it. tnsnames.ora and sqlnet.ora of 2003 machine and 2k machine are same. I'm not able figure out the exact problem.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply