Error "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" on x64 systems
|Article:TECH168219|||||Created: 2011-08-26|||||Updated: 2011-09-19|||||Article URL http://www.symantec.com/docs/TECH168219|
When creating a Data Connector Data Source using an excel spreadsheet (.xls or .xlsx), following error is seen.
I was not able to get a screenshot, please insert one if this is seen again.
The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
Symantec Management Platform 7.1 and later
Barcode Solution 7.1 and later
The dll mentioned in the error must be registered on the system. This dll is installed with Office 2007 and later but must be the x64 edition of MS Office when installed on a .64 server.
There are two methods to resolve this issue.
- Install MS Office 2007 x64 or later x64 version of MS Office.
- Alternately Microsoft provides an executable that will install the needed files without the need to install MS Office on the SMP. The following link will take you to the download location: http://www.microsoft.com/download/en/details.aspx?displaylang=en&WT.mc_id=soc-n-%5bTR%5d-loc-%5bServices%5d-%5bfarukc%5d&id=13255. Note: In the event that the download location becomes unavailable the name of the file is AccessDatabaseEngine_x64.exe and could be searched on Microsoft's download site.
Article URL http://www.symantec.com/docs/TECH168219