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?
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
We have this troubleshooting article that addresses this problem:
Using .Net Runtime version: '4.0.30319.34014' for test execution. Build version is '2012.2.1420.0'.
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.
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.
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.
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.