Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered


Overview

When working with an Excel data source, you may encounter error messages that indicate the Microsoft ACE OLE DB provider is not registered.

This error can be presented in many forms. 

Examples:

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine..

error message

The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.

An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. For more information, see http://go.microsoft.com/fwlink/?LinkId=219816. SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

The AcquireConnection method call to the connection manager "Data Source Forecast_Sales" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.


Resolution Process

These steps should be tried in the following order until the issue is resolved.

  1. Make sure the Jet Data Manager and Excel have the same bit-rate. If Excel is 32-bit, you will need to install the 32-bit version of the Jet Data Manager.  If Excel is 64-bit, you will need to install the 64-bit version of the Jet Data Manager.

  2. Install Microsoft Access Database Engine 2010 Redistributable.  These components can be found here: Microsoft Access Database Engine 2010 Redistributable

    Ensure that you explicitly run the executable as an administrator
  3. Install 2007 Office System Driver: Data Connectivity Components. These components can be automatically downloaded here: 2007 Office System Driver: Data Connectivity Components 

    Ensure that you explicitly run the executable as an administrator

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments