Why do I get error "The specified DSN contains an architecture mismatch between the Driver and Application"?

You get this error if you attempt to do the following on a Windows machine:

If you're using a 64-bit application, it will be linked against the 64-bit version of the Microsoft ODBC Driver Manager, which can only load a 64-bit ODBC driver. You can only connect to data sources for ODBC drivers that are listed in the 64-bit ODBC Data Source Administrator (accessible by running odbcad32.exe in the Windows Run dialog box).

Similarly, if you are using a 32-bit application, it will be linked against the 32-bit version of the Microsoft ODBC Driver Manager, which can only load a 32-bit ODBC driver. You can only connect to data sources for ODBC drivers that are listed in the 32-bit ODBC Data Source Administrator (accessible by running %windir%\syswow64\odbcad32.exe in the Windows Run dialog box).

If an ODBC driver is listed in both versions of ODBC Data Source Administrator, both a 32-bit and a 64-bit version of that driver are installed.

If you're unable to get the required ODBC driver for your application's architecture, use the ODBC-ODBC Bridge to:

Further information