MySQL Bugs: #81204: Error 1918 when install Connector/ODBC 5.3.6 x86; 2013 redistributable required

Bug #81204	Error 1918 when install Connector/ODBC 5.3.6 x86; 2013 redistributable required
Submitted:	26 Apr 2016 17:41	Modified:	3 Aug 2016 23:01
Reporter:	R. Gratis	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC Documentation	Severity:	S3 (Non-critical)
Version:	5.3.6	OS:	Windows (Windows Server 2012 R2 Standard x64)
Assigned to:		CPU Architecture:	Any

Description:
When running mysql-connector-odbc-5.3.6-win32.msi on Windows Server 2012 R2 Standard x64, I encountered the following error:

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 126: The specified module could not be found. ... \myodbc5S.d...

I had already installed the Microsoft Visual C++ 2010 Redistributable (x86), and tried reinstalling and rebooting the server before finally using Dependency Walker to determine that the myodbc5S.dll was looking for msvcr120.dll.

Installing Microsoft Visual C++ 2013 Redistributable (x86) provided the DLL and resolved the installation error for version 5.3.6 of the ODBC connector.

How to repeat:
Run the 5.3.6 installer on a system that does not provide msvcr120.dll (lacks the 2013 Visual C++ libraries).

Suggested fix:
If this is going to be the requirement moving forward, the documentation on the site should be updating to have users install the 2013 redistributable, rather than waste time troubleshooting this.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-windows.htm...

Screenshot of installer error

Attachment: 5.3.6-install-error.png (image/png, text), 8.21 KiB.

Hello R. Gratis,

Thank you for the bug report.

Thanks,
Chiranjeevi.

Posted by developer:
 
The error has been corrected by a recent edit to the C/ODBC manual:

http://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-windows.html

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 126: The specified module could not be found. ... \myodbc5S.d...

what the solution?
Please help me.
thank's

I installed version "mysql-connector-odbc-5.3.4-winx64.msi"
after copying

msvcp100.dll
msvcp100d.dll
msvcr100.dll
msvcr100d.dll
msvcr100_clr0400.dll
msvcr120.dll
msvcr120_clr0400.dll

to c:\Windows\SysWOW64\ 
and adding this directory to a system path

windows server 2012 r2

I had the same issue with this on Windows 2003 x64 SP2.

Installing VC Redistributable for Visual Studio 2013 (both 32 and 64 bit) resolved the issue for me.

In the error message it is stated that myodbc5S.d . . .  is missing.

The logical solution is to install this file in the appropriate folder.

For 32bit install the file here: C:\Windows\System32

File (myodbc5S.dll) can be downloaded here: 

https://www.pconlife.com/download/otherfile/79103/5bb0b7c4629cad667e6d2ed6d44ab6d4/

This works for me.

Question: I tried to install the same file in C:\Windows\SysWOW64 for the 64bit version. This did not work.

Can somebody tell me how to solve this?

Is it the wrong version of the file or the wrong location?