The Crazy ODBC driver for MySQL finally works

Problem:

Working on the tip below on different ODBC drivers and MySQL programs:

http://www.mssqltips.com/sqlservertip/2613/export-data-from-mysql-to-sql-server/

But keeping get an error complaining mismatch between architecture and application.

Finally, I figured it out.

Solution:

1. Install the 32-bit MySQL 5.5 (not 64-bit!)
2. Be sure to include the 32-bit ODBC driver 5.1.1. Do not use the 64-bit driver!
3. Use the 5.1.1 32-bit driver for ODBC driver, not the latest 5.2.