The specifiedDSN contains an architecture mismatch between the Driver and Application

如果报下面的错误信息：

The specifiedDSN contains an architecture mismatch between the Driver and Application

如果在64位的机器上用64 的ODBC，而IIS 是运行在32 位状态的，就会报这样的错误。

 

解决方法如下：

配置：

c:\windows\sysWOW64\odbcad32.exe.

 

这个ODBC 是 64 位 机器运行在 32位的 ODBC 。

 

如果要用回原来的。则切换为 ：

c:\windows\system32\odbcad32.exe.

 

即可。下面是相关文章：

 

To manage a data source that connects to a 32-bit driver under 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe. To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe.

If you use the 64-bit odbcad32.exe to configure orremove a DSN that connects to a 32-bit driver, for example, Driver do MicrosoftAccess (*.mdb), you will receive the following error message:

The specified DSN contains an architecture mismatch between the Driver andApplication

To resolve this error, use the 32-bit odbcad32.exe toconfigure or remove the DSN.