Unit Test Error – ERROR [IM014] [Microsoft][ODBC Driver Manager]

Monday, April 28, 2014

Visiting a customer we faced a strange problem running Coded UI with Excel Data Source: 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 The specified DSN contains an architecture mismatch between the Driver and Application The same test works on Windows 7 machines but received this error on Windows 8 64bit, So I start to investigating… First if opened odbcad32 (from Run command), I’ve noticed the “Excel Files” DSN exists but...