[Microsoft] [ODBC Driver Manager] in the specified DSN, the architecture between the driver and the application does not match

This problem occurs when you use ASP to connect to the MySQL database.

One afternoon, it was an ODBC data source problem.

Record it:

Cause of error: The 64-bit system uses 32-bit ODBC.

Workaround: Use 64-bit ODBC for no problem.

32-bit ODBC in the location: C:\Windows\System32\odbcad32.exe

64-bit ODBC in the location: C:\Windows\SysWOW64\odbcad32.exe

(The directory may differ for different systems)

A problem also occurs during the connection process:

[MySQL] [ODBC 5.3 (a) Driver] Unknown MySQL Server Host ' Loaclhost ' (2)

Cause of error: Server=localhost This sentence is wrong

Workaround: Change localhost to 127.0.0.1.

The specific reasons are unclear and need to be resolved.

[Microsoft] [ODBC Driver Manager] in the specified DSN, the architecture between the driver and the application does not match