[Solved] Error 1918 while Installing MySQL ODBC Driver on Windows

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 while Installing MySQL ODBC Driver

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, VCD:

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.

You can find Visual C++ Redistributable Packages for Visual Studio 2013 at
https://www.microsoft.com/en-us/download/details.aspx?id=40784

48 Comments

  1. Peter June 25, 2015
  2. linglom June 27, 2015
  3. Michaela July 24, 2015
  4. linglom July 25, 2015
  5. Ritesh October 8, 2015
  6. Asad November 29, 2015
  7. Rachel December 16, 2015
  8. linglom December 17, 2015
  9. Alexey February 1, 2016
  10. dan March 18, 2016
  11. erno March 21, 2016
  12. erno March 21, 2016
  13. VCD April 5, 2016
  14. Frank April 8, 2016
  15. thaukko May 1, 2016
  16. Nidelson Gimenes May 21, 2016
  17. Allan Odeke June 5, 2016
  18. DHuang June 10, 2016
  19. jags June 13, 2016
  20. Damien June 16, 2016
  21. Nihal Gupta July 7, 2016
  22. durlav gogoi July 17, 2016
  23. Peter July 28, 2016
  24. alex August 31, 2016
  25. Jamie September 14, 2016
  26. Saqib September 20, 2016
  27. Sree November 16, 2016
  28. aesel November 29, 2016
  29. Gabriel Barros November 30, 2016
  30. Joey Pruett January 19, 2017
  31. Coronado January 20, 2017
  32. Niall Mandal March 8, 2017
  33. abdulla April 6, 2017
  34. Josep June 22, 2017
  35. dan June 30, 2017
  36. Konrad August 2, 2017
  37. indra August 14, 2017
  38. Dean September 5, 2017
  39. Linda January 15, 2018
  40. juex January 25, 2018
  41. Lanio September 21, 2018
  42. peter October 2, 2018
  43. Matt October 14, 2018
  44. Mannjoro August 13, 2019
  45. god October 22, 2019
  46. Shoaib April 1, 2020
  47. addisu June 28, 2020
  48. addisu June 28, 2020

Leave a Reply