July 12, 2012

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

If you've ever experienced this error when trying to view the integration logs in Integration Manager, it's because one of two shared components is missing on the workstation -

Resolution 1
Install the Report Viewer Redistributable using the link below:
Resolution 2
Install the 2007 Office System Driver: Data Connectivity Components using the link below:

Try one or both of these resolutions and it should fix the issue for you.  And yes, you need to install the 2007 Office System Driver even though you have Office 2010 installed on the workstation.  Integration Manager looks for the 2007 version.

Alternatively - and I like this solution better - in Integration settings, you can direct the log to save as a local text file instead of in the IM database.  IMHO, viewing the log as a text file makes it easier to analyze.

No comments: