Microsoft.Jet.OLEDB.4.0 Provider Not Registered on Local Machine
Copyright © 2020 EarthSoft, Inc • Modified: 25 Feb 2020
Affected Software/Reports/DLL(s): EDP
Affected Software Version: N/A
Symptoms: The Microsoft.Jet.OLEDB.4.0 error message as shown below, may occur in EDP on machines running Microsoft Office 32-bit when attempting to load an EDD that is currently open in a Microsoft Office application (Excel, Access, etc). Closing the open EDD should resolve the issue.
An error has occurred in EarthSoft.EDP, Version=22.214.171.12439:
System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at EarthSoft.EDP.IO.ExcelFile.LoadWorkbookOleDb(String filename, EddFormatDefinition efd)
Cause/Details: This error may also occur when running 64-bit EQuIS Professional on a machine where a 32-bit Microsoft Office Suite and ACE provider are installed.
If the file is not open in a Microsoft Office application when the error occurs, it may indicate that the user's Microsoft JET provider is out of date or the Microsoft Access Database Engine needs to be installed. Recently, the JET provider was replaced with ACE. To resolve the error, you will need to install the ACE driver from the following link: http://www.microsoft.com/download/en/details.aspx?id=13255
Resolution/Workaround: Please note that the ACE version that matches the bitness of Microsoft Office Suite should be downloaded, not the bitness of the operating system.