Testing with Microsoft Test Manager(MTM) 2012

This post is written by ALM Support Escalation Engineer, Deepak Mittal. It explains the known issue when you run data driven unit tests in virtual environment with MTM in Team Foundation Server 2012

Problem Description:

When you run your data driven unit tests in virtual machine environment with MTM, you may get below errors:

The unit test adapter failed to connect to the data source or to read the data. For more information on troubleshooting this error, see "Troubleshooting
Data-Driven Unit Tests" (http://go.microsoft.com/fwlink/?LinkId=62412) in the MSDN Library. Error details: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.


There are few things to look at:

  1. If you are running your test in 32 bit mode, then you will have to install 32 bit version of excel.
  2. Then based on the connection string defined in your test for excel connectivity, you need to create DSN(Data Source Name) in virtual machines.
  3. Also, we need to make sure that the path of the excel should be proper in your connection string in the test.

Once these things are taken care, everything will come up fine. Hope this will be of immense benefit for testers community.

Written and Reviewed by:

Deepak Mittal

Support Escalation Engineer, Visual Studio ALM EMEA Team