How to install MyODBC in Windows 7?

Question

The downloaded installers from MySQL don't work - ie no mysql driver appears in the ODBC manager thing.

I've downloaded the mysql-connector-odbc-noinstall-5.1.6-win32 version, copied myodbc5.dll and myodbcS.dll to c:\windows\system32

C:\dump\bin>myodbc-installer -d -a -n "MySQL ODBC 5.1 Driver"  -t "DRIVER=
c:\windows\system32\myodbc5.dll;SETUP=c:\windows\system32\myodbc5S.dll"
Success: Usage count is 2

.. looks good but still no driver appears in the ODBC manager thing .

Help greatly appreciated.

Answer 1

It's not clear whether you're on a 32 or 64 bit Windows, but If you are 64, it probably makes sense that the installation works out, but the driver doesn't turn up in the dialog.

Check out this article: Installing MyODBC 3.51 on Windows 7 x64

Answer 2

Thanks Pekka, you're right (someone else just told me) there's another ODBC manager - \SysWOW64\odbcad32.exe which does show the installed driver. The winX64 MSI installer download works.

Thanks to all for the site.

John.