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

[Alan]

Hello,

We are having mixed results with being able to execute tests on a remote machine.  Some are able to run successfully while others produce this error message.  Has anyone come across this message?  Searches on Microsoft point to a version of Access Data Connectivity Components needing to be installed.  Microsoft Office is not installed on the remote machine.  How can certain tests run and others not?  Do we actually need to install the Data Connectivity Components?

Thanks...


Edit--more info...

The project that is successfully running has data bindings to an Excel 2003 workbook.
The projects that aren't successfully running have Excel 2007 workbooks.
I've tried saving the Excel 2007 workbooks as Excel 2003 workbooks, redoing the data-binding, but that still did not work.
I can successfully have both projects run on my local machine which has Office 2007 installed.

[Cody]

Hello Alan,

We have this troubleshooting article that addresses this problem:
http://www.telerik.com/automated-testing-tools/support/documentation/user-guide/troubleshooting_guide/test-execution-problems/unable-to-show-the-data.aspx

Regards,
Cody
Telerik

[Alan]

My fault, I remember searching for Microsoft.ACE.OLEDB.12.0 in your User Guide and receieved two results.  The first result didn't apply to my situation and I didn't check the second result, and of course this is the second result.

Thank you!

[Cody]

Hello Alan,

Thank you for the update, and glad I could help.

Regards,
Cody
Telerik

[Siva]

I Have the Same issue , My Test refere the data from Excel file Excel Version MS Office 2013

Using .Net Runtime version: '4.0.30319.34014' for test execution. Build version is '2012.2.1420.0'.
Starting execution....
 Detected a Silverlight Test. Setting EnableSilverlight=True
 Failure detected during execution. Details:
------------------------------------------------------------

- System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

[Cody]

Hi Siva,

We have recently moved our documentation to a new home. Here is the new link. To fix the problem you're running into simply install the 2007 Office System Driver: Data Connectivity Components.


Regards,
Cody
Telerik

 

[Matthew]

Just wanted to provide a quick note for anyone that encounters this:

I used Cody's link in the above post and installed the 64 bit version of Microsoft Access Database Engine 2010, which did not work.

Note that Telerik's documentation states, "This (the problem) could be observed also if the Microsoft Office package is 64-bit version." The 32 bit version must be installed for this error to be resolved.

[Elena]

Hi Matthew,

Thanks very much for the mentioned note - it is completely valid and I will take care the information listed in the article on the topic to be organized better. 

Regards,
Elena Tsvetkova
Progress Telerik