The architecture mismatch between the driver and the application in the specified DSN

(Note: This article is still in the test ...)

I. Problems

64-bit win7+32-bit Excel, with MySQL 64-bit driver installed,

Create a new MySQL data source: Control Panel--management tools-data source (ODBC)--pop-up "Data Source Manager" dialog box--add--Choose MySQL ODBC 5.2w driver--complete--In the pop-up "MySQL CONNECTOR/ODBC data Source Configuration dialog box, enter data Source name mytest (custom), TCP/IP server is localhost,user for Root,password null, Select a database in the DB Drop-down list and test the connection success with the Click Test button-complete the data source creation.

Then connect the MySQL data source in Excel: Data--from other sources--from Microsoft query--Select a data source mytest

Error message: The architecture mismatch between the driver and the application in the specified DSN.

Ii. Solutions

Excel is 32-bit, to use 32 of the MySQL driver to build a data source, then install 32-bit MySQL driver, the original 64-bit driver is not deleted, for two drivers can be used. So, how do you choose which drive to set up your data source?

The key is the following two programs:

C:\windows\system32\odbcad32.exe, call 64-bit driver to set up data source C:\windows\sysWOW64\odbcad32.exe, call 32-bit driver to set up data source. Depending on the number of digits in your application such as Excel, you can do the above program. Careful observation shows that both will bring up the Data Source Manager dialog box, but the content appears different when you click the Add button.

In the beginning of this article Control Panel--management tools--data source (ODBC) to establish a data source is actually called the 64-bit driver, so there will be an error.

--This article from: http://blog.csdn.net/ikaoni/article/details/49132375

I was in reverse engineering with a Powerdisigner error:

Select Database---connection (connect).

Select the ODBC data source that is already configured.

I previously downloaded 64 for the MySQL ODBC driver, and then installed a 32-bit driver, and then reconnect, no error.