Unable to show data

PROBLEM 1

When running a data driven test on remote machine you get your test failed and the following exception in the log:

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

This happens on machines where Excel databinding is used, however neither Excel or data connectivity component is installed.

PROBLEM 2

No sheets are listed to select from when data binding a test:

No sheets

SOLUTION

Simply install Microsoft Data Connectivity Components in order to get rid of this problem.

Note: You should install the 32 bit version.