MYSQL ODBC driver install errors on 3.1 server

server administration XI Server Discussion
1

All,

I am trying to install mysqlodbc5.2.6 driver (32bit) on the XI 3.1 SP3 windows 2008 server and get the below errors.

Product: MySQL Connector/ODBC 5.2 – Error 1918.Error installing ODBC driver MySQL ODBC 5.2 Unicode Driver, ODBC error 13: The setup routines for the MySQL ODBC 5.2 Unicode Driver ODBC driver could not be loaded due to system error code 193: … Verify that the file MySQL ODBC 5.2 Unicode Driver exists and that you can access it.

Product: MySQL Connector/ODBC 5.2 – Error 1918.Error installing ODBC driver MySQL ODBC 5.2 ANSI Driver, ODBC error 13: The setup routines for the MySQL ODBC 5.2 ANSI Driver ODBC driver could not be loaded due to system error code 193: … Verify that the file MySQL ODBC 5.2 ANSI Driver exists and that you can access it.

3.1 ships with default MYSQL database for CMS but we have it on Oracle. I am assuming the install is finding MYSQL entries on the server and erroring out but I am not seeing any MYSQL drivers in the 32 bit ODBC manager. I am trying to install the driver and create odbcs for a new customer db.

Any insight is greatly appreciated.

Thanks.

boxiadmin :us: (BOB member since 2007-03-09)

2

Hi,

Please check if the driver you are installing is compatible with win 2008 server.
Also if there are any Mysql entries in registry then delete in and try to install it again.

~Unmesh

Unmesh702 :india: (BOB member since 2009-02-19)

3

Hi Unmesh, Thanks for the reply. I had both steps done already but it didn’t help. But found the solution somehow.

Solution:

Install Microsoft Visual C++ 2010 Redistributable Package (x86) on the server for 32bit ODBC drivers and (x64) for 64bit ODBC drivers. Having Microsoft Visual C++ 2008 or 2012 will not help.

Hope this helps…MYSQL is a pain in everyway! :cuss:

boxiadmin :us: (BOB member since 2007-03-09)