How to install MyODBC on Windows 7?

Question

Loaded installers from MySQL do not work - that is, the mysql driver does not appear in the ODBC manager.

I downloaded 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 nothing appears in the ODBC manager.

Help with thanks.

Answer 1

It is not clear whether you are using 32-bit or 64-bit Windows, but if you are 64, it probably makes sense that the installation works, but the driver does not appear in the dialog box.

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

Answer 2

Thank you, Pekka, you're right (someone else told me), there is another ODBC manager - \ SysWOW64 \ odbcad32.exe, which shows the installed driver. The download of the WinX64 MSI installer is loading.

Thanks to everyone for the site.

John.

Answer 3

The disgusting thing is that the control panel will display an item called "ODBC (32-bit)", but in fact it invokes 64-bit ODBC administration on 64-bit Windows (located irresponsibly in c:\windows\system32\odbccp32.cpl ).

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

Answer 4

version of mysql-connector-odbc-noinstall-5.1.6-win32.zip can only be installed on a 32-bit 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 the 32-bit and 64-bit drivers in the correct locations.