MySQL Bugs: #72292: The setup routines for the MySQL ODBC 5.3 Unicode Driver

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:	Windows (Version 7)
Assigned to:		CPU Architecture:	Any

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"

Please check workarounds mentioned at http://bugs.mysql.com/bug.php?id=70661 . Thanks.

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

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.

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.

Hi
Paul thank you very much, that was great 
thank you

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.

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.

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