I have setup a linked server that intermittently crashes.
It connects to an Oracle 9i 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?
I'm trying to connect to Oracle 9i database