Error "Failed to load list of tables/sheets. The 'Microsoft.ACE.OLDEDB.12.0' provider is not registered on the local machine." occurs when trying to use Data Connector 7.1 with an Excel data source
| Article:TECH158045 | | | Created: 2011-04-13 | | | Updated: 2011-04-13 | | | Article URL http://www.symantec.com/docs/TECH158045 |
Problem
When trying to use a Data Connector 7.1 data source to use an Excel file, the error "Failed to load list of tables/sheets. The 'Microsoft.ACE.OLDEDB.12.0' provider is not registered on the local machine." occurs.
Environment
Data Connector 7.1
Cause
Microsoft does not provide a 64-bit version of the Microsoft OLDEDB.12.0. Installing the 32-bit version onto the 64-bit Symantec Management Platform 7.1 does not enable it to work.
Solution
Download and install the Microsoft Access Database Engine 2010 Redistributable (64-bit) from the following Microsoft page:
AccessDatabaseEngine_x64.exe
http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d
Afterwards, open a Data Connector data source, point it to an Excel file, and the error no longer appears. The workbook pages can now be accessed.
Note: For 32-bit versions of Data Connector, this error refers to the missing Microsoft OLDEDB.12.0 on the Altiris server. This can be downloaded at the following Microsoft page:
2007 Office System Driver: Data Connectivity Components
http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en
|
|
Article URL http://www.symantec.com/docs/TECH158045
Terms of use for this information are found in Legal Notices
Thank you.