OLE DB provider Error

[darkwing75]

I encountered this error when looking at my Linked Servers (which are connected to MS Access databases on the network)

Error 7399: OLE DB provider 'Micirosft.Jet.OLEDB.4.0' reported an error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize::Initialize returned 0x80004005:].

Any ideas? It goes away when I restart the SQL Server and I can connect to my MS Access databases again. Thanks!

 

[martynh]

This error is, I'm afraid, something of a bucket error reporting 'something went wrong'. If you use linked servers for a while you get very familiar with it. All it's saying is SQL Server failed to run the initialize method.

As for tracking the real cause, you will just have to look around for other problems. However, it sounds like your linked server definitions and data sources are valid so there may not be a cause that you can track down.

 

[darkwing75]

Yup, this is really a hard one to crack, the links were working fine a few weeks ago, now, it suddenly stops working unless I have to restart SQL server, this is really a headache for us, another Microsoft feature I suppose..