Which ODBC driver should we install on 64-bit machine using Windows Server 2008 R2, Windows Server 2012, Windows 7, or Windows 8? It would depend. When I installed MySQL ODBC 64-bit driver on Windows 8.1 Preview, it worked when I added a new DSN. But, it did not work when Microsoft Access 2007 application made ODBC call to MySQL server.
What wrong? It took me couple hours to figure out. Microsoft Access 2007 may not work with other 64-bit driver or program yet. Installed MySQL ODBC 32-bit solve the problem.
On Windows 8.1, there are two ODBC Administrors under Control Panel – Administrative Tools. One for ODBC Datasources 32-bit and one for ODBC Datasources 64-bit. On Windows Server 2008 R2, there is only one reference to ODBC Administrator. This is 64-bit. Where is 32-bit? To add or manage DSN for ODBC 32-bit, you need to call program odbcad32.exe in C:\Windows\SysWOW64\
Hope this help.