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.
