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.
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
0
Accepted
Hello Alan,
Cody
Telerik
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
Cody
Telerik
0
Alan
Top achievements
Rank 2
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!
Thank you!
0
Hello Alan,
Cody
Telerik
Thank you for the update, and glad I could help.
Cody
Telerik
0
Siva
Top achievements
Rank 1
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.
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
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
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
0
Matthew
Top achievements
Rank 1
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
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
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