Install MySQL ODBC connector prompt error 1918 perfect solution (non installation of VC + + library method)

Local environment:
operating system – windows7 32 bit
MYSQL version – MYSQL Ver 14.14 Distrib 5.7.25, for Win32 (AMD64)
Execution process:

    start – control panel – systems and security – management tools – data source (ODBC) wanted to add MYSQL, found that MYSQL could not be found. An error was reported during the installation of mysql-Connector-ODBc-8.0.15-Win32 (mysql 5.7 supported) on the official website.

Error contents:

Error installing ODBC driver MySQL ODBC5.3 ANSI
Driver,ODBC error 13:Unable to load MySQL ODBC5.3 ANSI Driver ODBC driver
Installation routine, because there is a system error code 126: ... \Myodbc5S.dll) cannot find the specified module.

Solutions:
Solution 1: general online solution: install Microsoft Visual C++ 2013 Redistributable Package above. Verification results: Installing mysql-Connector-ODBC still prompts for the same error message after the following three versions are installed on the machine.

Microsoft Visual C++ 2015 Redistributable Package
Microsoft Visual C++ 2013 Redistributable Package
Microsoft Visual C++ 2010 Redistributable Package

Solution 2: Replace the lower version of mysql-Connector-ODBC. Try installing mysql-connector-odbc-5.1.13-win32.msi verification solution :(the current environment has all three versions of vc++ installed) install the lower version (5.1.13) successfully! The ODBC data source manager was able to successfully create the user data source.


Read More: