Error 1918 error installing odbc driver mysql odbc 5.1 driver

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.

Had to install MySQL ODBC Driver on Windows when I was trying to use SSMA to convert a MySQL DB to Microsoft SQL. When I tried to install the driver, I got the below error and was completely puzzled. I finally found the fix..

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.dll…

MySQL ODBC Error 1918

The fix is actually quite simple. Install Visual C++ Redistributable Packages for Visual Studio 2013. If you are trying to install later versions than 5.6.3, you may need a newer version of the Redistributable Packages. You can download the packages from Microsoft from the link below. Just be sure to get the right arch (x86, x64). This depends on what version ODBC you are install, but I just installed both on my server.

Visual C++ Redistributable Packages for Visual Studio 2013

At time of writting, you do not need 2015, but in case a future version is released that needs it, below is the link to that:

Are you having trouble with the MySQL Error 1918: Installing ODBC driver? Fear not, our experts have the solution. Our MySQL Support team is here to lend a hand with your queries and issues.

How to fix – MySQL Error 1918: Installing ODBC driver

The MySQL Error 1918 often occurs due to MySQL 5.5.9 Unicode preventing proper configuration of the ODBC database for Land F/X. Fortunately, we can easily resolve this issue with a little help from our in-house experts. Let’s take a look at how we can fix this issue and get MySQL functioning in no time.

1. First, we have to install C++ Runtime for 2013 after downloading it from this link.

   If we still run into MySQL Error 1918, our experts recommend moving on to the next step.

2. If the previous step does not resolve the error, we have to install a backdated MySQL driver and then configure ODBC with this backdated version. According to our experts, version 5.1.12 works well in this scenario.
   We can easily find the following version on the MySQL website.

   Once we download the MSI installer, we can easily install the ODBC drivers manually. This allows us to bypass MySQL Error 1918 and get the MySQL connection functioning in no time.

Let us know in the comments if the above fix worked for you. Our experts are here to help you get the MySQL connection sorted out easily.

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

To conclude, our Support Engineers demonstrated how to resolve the MySQL Error 1918: Installing ODBC driver without too much trouble. We got to see how installing a backdated version fo MySQL driver can help get the MySQL connection function.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

You have downloaded MySQL Connector/ODBC (ODBC driver) from MySQL – Connector/ODBC. And when you’re trying to install it on Windows, you receive error message similar as the following:

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.dll...

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.dll...

Solution

MySQL Connector/ODBC requires Microsoft Visual C++ 2010 redistributable so you have to install it first.

If you want to install MySQL Connector/ODBC 32-bit version, you have to download and install Microsoft Visual C++ 2010 Redistributable Package (x86).

If you want to install MySQL Connector/ODBC 64-bit version, you have to download and install Microsoft Visual C++ 2010 Redistributable Package (x64).

After you installed Microsoft Visual C++ 2010 redistributable, you can try reinstall MySQL Connector/ODBC again, the issue should be resolved this time.

Added solution from a user, :

For me, I am installing mysql-connector-odbc-5.3.6-win32.msi, Microsoft Visual C++ 2010 Redistributable Package (x86) doesn’t work for me. However Visual C++ Redistributable Packages for Visual Studio 2013 works.

What is System Error 126 MySQL ODBC driver?

126 - This error means that the ODBC driver itself (DLL file) cannot load its dependency files. This could be because the database client software is not installed or its working directory (usually called "bin") is not in the Windows search path for this computer.

What is access denied for user in MySQL ODBC driver?

You will get this error when the user user_name does not have the right to access your MySQL database. To resolve the error, you must create a user with the following command: mysql> GRANT ALL ON *. * to user_name@localhost IDENTIFIED BY 'password';

Does ODBC need MySQL connector?

You may need Connector/ODBC for Unix or macOS if you have an application that requires an ODBC interface to communicate with the database. Applications that require ODBC to communicate with MySQL include ColdFusion, Microsoft Office, and Filemaker Pro.