How to install MyODBC in Windows 7?

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.

---

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

---

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.

---

The nasty thing about this is that Control Panel will show an item entitled "ODBC (32-bit)", but this actually invokes the 64-bit ODBC administration in 64-bit Windows (irresponsively located at c:\windows\system32\odbccp32.cpl).

To get to the 32-bit ODBC administration, either use odbcad32.exe as mentioned by other posters, or invoke control c:\windows\syswow64\odbccp32.cpl.

---

mysql-connector-odbc-noinstall-5.1.6-win32.zip version can only be installed on a 32bit system, see MySQL documentation

It states that:

The following instructions only work for 32-bit Windows systems. If you have a 64-bit Windows system, use the MSI installer, which installs both the 32-bit and 64-bit drivers to the correct locations.