MySQL ODBC driver unavailable

[xyla]

MySQL ODBC driver is unavailable in the dropdown listbox when I want to add a new ODBC connection.

This after upgrading from Plesk 7.5.6 -> 7.6.0

It's not possible to re-install the driver in Plesk setup because the un-install option is unavailble for this component.

 

[xyla]

Solution:

First, check output of the following command:

C:\Program Files\SWsoft\Plesk\admin\bin>odbcmng.exe --get-drivers-list

Find in it "MySQL ODBC 3.51 Driver" line.

If there is no such line then you should try to reinstall mysql odbc driver.

If there is that line than you should check C:\Program Files\SWsoft\Plesk\admin\bin\odbc.conf.xml file. There should be something like:

<cstring driver="VDatabase ODBC 3.51 Driver" driverType="mysql">

Change "VDatabase ODBC 3.51 Driver" to "MySQL ODBC 3.51 Driver".

Save old file odbc.conf.xml before changing.