« Archives in October, 2013

MySQL Connector/ODBC 5.2 Installation – Error 1918/System Error Code 126 work around

The other day I was installing MySQL Connector ODBC 5.2.6 x64 (mysql-connector-odbc-5.2.6-winx64.msi) on a Windows 2008 Server R2 and I keep getting an error message about a module that could not be found.  The exact error in event viewer was:

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 126: The specified module could not be found. (C:\Program Files\MySQL\Connector ODBC 5.2\myodbc5S.dll).. Verify that the file MySQL ODBC 5.2 ANSI Driver exists and that you can access it.

So after searching for a while on Google and without any success, I get out the trusty old SysInternals ProcMon and monitor the installation of the MySQL Connector.  Come to find out the installation was looking for a specific .NET dll on the system that was not there.  So I search on Google some more regarding this file missing.  Someone else had the same problem when installing a completely different application.  So I followed their advice of copying C:\Windows\System32\msvcr100_clr0400.dll to C:\Windows\System32\msvcr100.dll and continued with the install.  The process worked and the driver was successfully installed and tested.

Just thought other people might find that tip useful.