Error connecting to Oracle 9i Database using SQL Linked Server : MSDAORA Error

I have setup a linked server that intermittently crashes.

It connects to an Oracle Database on an alternate server. My tnsnames.ora file is correct and the Linked server does periodically work....

I am not sure what triggers it but it crashes and gives the following error:

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

OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].

Can anyone help with this please ?

Which is the correct configuration in terms of drivers to use and vendor. Are there any registry settings that need changing?

Thanks,

Simon.

[785 byte] By [SimonNainkin] at [2008-2-28]