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:Microsoft Windows (Windows Server 2012 R2 Standard x64)
Assigned to: CPU Architecture:Any

[26 Apr 2016 17:41] R. Gratis
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...
[26 Apr 2016 17:41] R. Gratis
Screenshot of installer error

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

[27 Apr 2016 5:02] Chiranjeevi Battula
Hello R. Gratis,

Thank you for the bug report.

Thanks,
Chiranjeevi.
[3 Aug 2016 23:01] Daniel So
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
[8 May 2017 7:35] Nurul Hadi
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
[24 Jun 2017 20:11] Eduard Karamanyants
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
[27 Jul 2017 23:41] Helpdesk RRP
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.