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

Excel data binding error - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

2 Answers 898 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Matthew
Top achievements
Rank 1
Matthew asked on 19 Jun 2019, 04:28 PM

When we try to execute a test list on a remote Execution/Scheduling (all in one) Server, we get an exception:

 

[06/19 12:02:55,ArtOfTest.Runner.exe(436:1),Error] ExcelDataSource.GetDataUnfiltered() : EXCEPTION! (see below)
     Situation: Error reading from Excel database.
     Outer Exception Type: System.InvalidOperationException
     Message: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
     HRESULT: 0x80131509 (Official ID (if app.) = COR_E_INVALIDOPERATION, Error Bit = FAILED, Facility = FACILITY_URT, Code = 5385)
     Call Stack:
          at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
          at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
          at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)


This test uses data binding (Excel) to perform the test. A similar error message appeared in another forum thread. Telerik's last response provided a link to their documentation that states that Microsoft Access Database Engine 2010 needs to be installed. Our team installed this on the Execution/Scheduling Server, but the same exception is occurring. The server was restarted and the we tried re-installed Microsoft Access Database Engine 2010 to no avail.

 

The thread referenced above also referred to 2007 Office System Driver: Data Connectivity Components, which is a broken link, and I'm guessing that Microsoft Access Database Engine 2010 is the now recommended version since it is in your documentation.

 

To note, when a test list does not use an Excel data binding, the test runs properly.

________________________________________________________________________________________________

Environment Description:

  • Server 1: Scheduling and Execution (Test Studio Runtime)
  • Server 2: Test Studio where testers create tests. They run these tests remotely on Server 1.

2 Answers, 1 is accepted

Sort by
0
Matthew
Top achievements
Rank 1
answered on 19 Jun 2019, 05:48 PM

I discovered that installed the Microsoft Access Database Engine 2010 64 bit version does not solve the issue. Once I installed the 32 bit version, the error was resolved. I added a comment to the post that I referenced above in case anyone else encounters this issue.

Telerik, could you please delete this thread as it is no longer needed? Thanks!

0
Elena
Telerik team
answered on 20 Jun 2019, 11:50 AM
Hi Matthew,

Thanks very much for your cooperation and feedback in exploring and fixing the encountered issue. 

As you have stated the required installation is the Microsoft Access Database Engine 2010 and to be more precise its 32-bit version. The article on the topic mentioned in the other thread you pointed to contains the necessary details. However, I suppose the information may be organized in a more obvious manner and I will take this into consideration. 

Anyways, thanks once again for your time. 

P.S. Since the thread cannot be deleted, I will proceed by closing it. 

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
Matthew
Top achievements
Rank 1
Answers by
Matthew
Top achievements
Rank 1
Elena
Telerik team
Share this question
or