April 17, 2014

Resolving Error 1918, System Error Code 126, When Installing MySQL ODBC Driver

If you are installing MySQL ODBC Driver and encounter the following error:

Error 1918. Error installing ODBC driver MySQL ODBC 5.1 Driver, 
ODBC error 13: The setup routines for the MySQL ODBC 5.1 Driver 
could not be loaded due to system error code 126: 
The specified module could not be found. 
...\myodbc5S.dll).. Verify...

Then you will need to install the Microsoft Visual C++ 2010 Redistributable Package (select the appropriate one for your OS architecture below): 64-bit version: http://www.microsoft.com/en-us/download/confirmation.aspx?id=14632 32-bit version: http://www.microsoft.com/en-gb/download/details.aspx?id=5555 After installing that, then re-attempt installing the MySQL ODBC connector, and things should work smoothly. Hope this helps.

About Chris Calender

Chris Calender is a Principal Support Engineer with MariaDB. Prior to joining SkySQL (which later merged with MariaDB) he was a Principal Support Engineer at MySQL/Sun/Oracle, as well as Support Manager of Americas East. Before that, he worked as a MySQL DBA and developer for numerous Fortune 500 Companies, including Clear Channel, Western & Southern, and Cincinnati Bell. Chris has both Bachelor's and Master's degrees in Computer Science, from Miami University and the University of Cincinnati, respectively. He has been using MySQL since 3.23 days. Having deployed well into the tens of thousands of database servers, he is an expert at deployment, managing such instances, server tuning and query tuning. In the past, he devised a revolutionary technique for recovering corrupted, and what was then unrecoverable data, thus saving some companies completely, as well as setting himself apart in the MySQL/MariaDB ecosystem as such as expert. He has also been very willing to share his knowledge as he has been one of the most prolific bloggers in the MySQL Ecosystem (see planet.mysql.com), ranking on the "Top 20 Authors" list for much of the past 10 years, and even holding the #1 spot numerous times.

Read all posts by Chris Calender