This is a migrated thread and some comments may be shown as answers.

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

7 Answers 38 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Alan
Top achievements
Rank 2
Alan asked on 22 Aug 2013, 08:20 PM
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.

7 Answers, 1 is accepted

Sort by
0
Accepted
Cody
Telerik team
answered on 23 Aug 2013, 04:34 AM
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
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Alan
Top achievements
Rank 2
answered on 23 Aug 2013, 11:25 AM
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!
0
Cody
Telerik team
answered on 23 Aug 2013, 01:33 PM
Hello Alan,

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

Regards,
Cody
Telerik
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Siva
Top achievements
Rank 1
answered on 05 Jan 2015, 06:13 PM
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.
0
Cody
Telerik team
answered on 05 Jan 2015, 08:09 PM
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
 
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Matthew
Top achievements
Rank 1
answered on 19 Jun 2019, 05:46 PM

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.

0
Elena
Telerik team
answered on 20 Jun 2019, 11:52 AM
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
 
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
Tags
General Discussions
Asked by
Alan
Top achievements
Rank 2
Answers by
Cody
Telerik team
Alan
Top achievements
Rank 2
Siva
Top achievements
Rank 1
Matthew
Top achievements
Rank 1
Elena
Telerik team
Share this question
or