Microsoft KB Archive/818182

= You receive an &quot;Unspecified error&quot; error message when SQL Server accesses a linked server that uses Microsoft OLE DB provider for Jet 4.0 =

Article ID: 818182

Article Last Modified on 12/9/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft OLE DB Provider for Jet 4.0
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Workgroup Edition

-



SYMPTOMS
When you run a linked server query that is configured to use Microsoft OLE DB provider for Jet 4.0, the query might fail and you receive the following error message:

Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.

[OLE/DB provider returned message: Unspecified error]

OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].

When you locate and access the linked server in SQL Server Enterprise Manager, you might receive the following error message:

Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.



CAUSE
You have the wrong version of Microsoft Jet 4.0 (Msjet40.dll) on the database server.



RESOLUTION
This problem has been fixed in the latest edition of the Jet Service Pack. For additional information about how to obtain the latest version of the Jet 4.0 database engine, click the following article number to view the article in the Microsoft Knowledge Base:

239114 How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine

324944 List of MDAC Fixes in Windows 2000 Service Pack 3

