Re: MYsql not appear in list of ODBC data sources

[Bogdan Degtyariov]

Hi Salih,

You might be experiencing this problem because Windows has two separate ODBC Administrator programs:

- One is for 32-bit Data Sources and Drivers:
%windir%\SysWOW64\odbcad32.exe

- Another is for 64-bit Data Sources and Drivers:
%windir%\System32\odbcad32.exe

The ODBC Administrator shortcut in the Control Panel is 64-bit. If you need the 32-bit version it has to be run using the path provided above. Press Win + R and then copy/paste the path in the Run dialog prompt.

You need to make sure that ODBC Administrator you are running correspond to the version of MySQL ODBC drivers installed in the system.

NOTE: it is possible to have both 32-bit and 64-bit MySQL ODBC Driver installed in the system. They will not clash. However, if client program is 32-bit it will only be able to use a 32-bit ODBC driver. The same is true for 64-bit client and 64-bit driver. Mixing 32 and 64 bit libraries and clients is not allowed.

I hope it helps.