Monday, February 22, 2016

How to fix: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Our full-state calendar migration executes on a 32-bit or 64-bit architecture.  We default to using the JET database engine, though this can be changed in _Config_XML:
 Provider=Microsoft.ACE.OLEDB.12.0;Data Source=
If you don't have the x64 version of MS Office 2010 installed, (or NO version of office installed) download the Microsoft Access DB Engine 2010 Redistributable (pick the x64 version!)
http://www.microsoft.com/download/en/details.aspx?id=13255  Install the x64 version via the Command Prompt with: 
AccessDatabaseEngine_X64.exe /passive
Do it this way OR you'll see the error:  The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

The error will look like this in the error window of our migration tools:




 If you look in _Config_XML you will see the default (top line) as well as the other options should you need to change them.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=
PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=

No comments: