DataDriven Unit Test using Excel in VS2013

Question

I am creating a Datadriven Unit (MS Unit Test) using an Excel file (*. Xlsx) as a data source. this is a mistake with the following error

Reverse message: the unit test adapter could not connect to the source data or to read data. For more information on troubleshooting this error, see the "Troubleshooting Data Management Issues" section. ( http://go.microsoft.com/fwlink/?LinkId=62412 ) in the MSDN library. Error Details: ERROR [IM014] [Microsoft] [ODBC Driver Manager] The specified DSN contains an architecture mismatch between the driver and the Application

I set the Copy to Output directory: always for DateRangeTest.xlsx I also tried defaultdir=.\;, defaultdir=.;anddefaultdir=c:\projectName\bin\debug\;

Here is the section from app.config

<configSections>
    <section 
      name="microsoft.visualstudio.testtools" 
      type="Microsoft.VisualStudio.TestTools.UnitTesting.TestConfigurationSection, Microsoft.VisualStudio.QualityTools.UnitTestFramework, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
     />
  </configSections>
  <connectionStrings>
    <add name="DateRangeConstr" 
      connectionString="Dsn=Excel Files;dbq=DateRangeTest.xlsx;defaultdir=.\; driverid=790;maxbuffersize=2048;pagetimeout=5" 
      providerName="System.Data.Odbc" />
  </connectionStrings>
  <microsoft.visualstudio.testtools>
    <dataSources>
      <add name="DateRangeTestDataSource" 
        connectionString="DateRangeConstr" 
        dataTableName="Sheet1$" 
        dataAccessMethod="Sequential"/>
    </dataSources>
  </microsoft.visualstudio.testtools>

Answer 1

Here are (2) options - you can either remove the DSN requirement , or set the opposite of the execution speed of the Excel / Access Office product that you installed.

Option 1 - remove the DSN from the connection string

Change this:

<add name="DateRangeConstr" 
    connectionString="Dsn=Excel Files;dbq=DateRangeTest.xlsx;defaultdir=.\; driverid=790;maxbuffersize=2048;pagetimeout=5" 
    providerName="System.Data.Odbc" />

For this:

<add name="DateRangeConstr" 
    connectionString="dbq=DateRangeTest.xlsx;defaultdir=.\; driverid=790;maxbuffersize=2048;pagetimeout=5" 
    providerName="System.Data.Odbc" />

Option 2 - Install ODBC Drivers for the Opposite Witness

• For Office x64, install Redistributable Microsoft Access Database Engine 2010 for x86 (AccessDatabaseEngine.exe)
• Office x64 Microsoft Access Database Engine 2010 x64 (AccessDatabaseEngine_x64.exe).

, Office 2010 Office 2013.

, Excel Files DSN x86 x64 .

• 32- ODBC: %WINDIR%\SysWOW64\odbcad32.exe
• 64- ODBC: %WINDIR%\System32\odbcad32.exe

" Excel", "", . "" , , .

Answer 2

- , Excel.

, Visual Studio Data Source Explorer.

. , Data Driven (Parameters) Visual Studio.