Bug #72292 The setup routines for the MySQL ODBC 5.3 Unicode Driver - error code 193
Submitted: 9 Apr 2014 15:53 Modified: 10 Apr 2014 15:04
Reporter: Paul Foss Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.3 OS:Microsoft Windows (Version 7)
Assigned to: CPU Architecture:Any

[9 Apr 2014 15:53] Paul Foss
Description:
Have installed "mysql-connector-odbc-5.3.2-win32.msi" and got an error message 

Error 1918. Error installing ODBC driver MySQL ODBC 5.3 ANSI Sriver, ODBC error 13........

I "ignored", and again for the Unicode message.

The drivers appear in the ODBC admin screens (C:\Windows\SysWOW64\odbcad32.exe)
but when I try to setp up a new datasource I get the error message

The setup routines for the MySQL ODBC 5.3 Unicode Driver ODBC driver could not be loaded due to system error code 193.

I have scoured these pages, and the web for fixes (running vcredist_x64 or vcredist_x86), or editing the registry, but all to no avail.

I'm running Windows 7 Ultimate

Help someone please!!!

How to repeat:
C:\Windows\SysWOW64\odbcad32.exe

User DSN tab.

Add. 

Select "MySQL ODBC 5.3 Unicode Driver"
[9 Apr 2014 16:06] Miguel Solorzano
Please check workarounds mentioned at http://bugs.mysql.com/bug.php?id=70661 . Thanks.
[9 Apr 2014 19:15] Paul Foss
Hi there,

Yes, I've worked through this thread before. Here is what I found.

1. no-install zip package - done. no effect

2. REGISTRY (heavily edited)

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\MySQL ODBC 5.3 ANSI Driver]
"UsageCount"=dword:00000002
"Driver"="C:\\Program Files (x86)\\MySQL\\Connector ODBC 5.3\\myodbc5a.dll"
"Setup"="C:\\Program Files (x86)\\MySQL\\Connector ODBC 5.3\\myodbc5S.dll"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\MySQL ODBC 5.3 Unicode Driver]
"UsageCount"=dword:00000002
"Driver"="C:\\Program Files (x86)\\MySQL\\Connector ODBC 5.3\\myodbc5w.dll"
"Setup"="C:\\Program Files (x86)\\MySQL\\Connector ODBC 5.3\\myodbc5S.dll"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers]
"MySQL ODBC 5.3 ANSI Driver"="Installed"
"MySQL ODBC 5.3 Unicode Driver"="Installed"

The drivers are in the list, pointing to the right place.
The files are definitely there.

3. Installing Microsoft Visual C++ 2010 redistributable (32 bit)-

I have tried both - vcredist_x64 and vcredist_x86
Neither seem to have worked.

4. I've tried copying C:\Windows\System32\msvcr100_clr0400.dll to C:\Windows\System32\msvcr100.dll but it makes no difference. 

5. Event Viewer reports the following

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

and

Product: MySQL Connector/ODBC 5.3 -- Error 1918.Error installing ODBC driver MySQL ODBC 5.3 Unicode Driver, ODBC error 13: The setup routines for the MySQL ODBC 5.3 Unicode Driver ODBC driver could not be loaded due to system error code 193: .. Verify that the file MySQL ODBC 5.3 Unicode
[10 Apr 2014 15:04] Paul Foss
I have now fixed this issue.
It was related to the other problems, but the fix was slightly more involved.

Replacing the dlls mentioned below from a machine that is working solves the problem:

c:\Windows\SysWOW64\msvcp100.dll
c:\Windows\SysWOW64\msvcp100d.dll
c:\Windows\SysWOW64\msvcr100.dll
c:\Windows\SysWOW64\msvcr100_clr0400.dll
c:\Windows\SysWOW64\msvcr100d.dll

Thanks.
[8 May 2014 9:53] David Romero
Paul... THANKU THANKU THANKU SO F*CKING MUCH!!! i have been fighting with that installer for DAYS! and browsing for countless hours searching for a solution, thank you again.

Regards, David.
[2 Nov 2014 6:46] Sh N
Hi
Paul thank you very much, that was great 
thank you
[15 Dec 2014 8:09] Saleem Kadiwal
The package installs successfully with Microsoft Visual C++ 2010 redistributable installed just check that Microsoft Visual C++ 2010 redistributable 32bit is required for 32bit ODBC driver and Microsoft Visual C++ 2010 redistributable 32bit for 64bit ODBC driver.
[15 Dec 2014 8:13] Saleem Kadiwal
Correction...

The package installs successfully with Microsoft Visual C++ 2010 redistributable installed just check that Microsoft Visual C++ 2010 redistributable 32bit is required for 32bit ODBC driver and Microsoft Visual C++ 2010 redistributable 64bit for 64bit ODBC driver.
[3 Sep 2015 23:19] Christopher Abichandani
Be sure to use the x64 version of the c++ redist if you are trying to install the 64-bit connector/ODBC. I found it here: http://www.microsoft.com/en-us/download/confirmation.aspx?id=14632