Bug #70661 Cannot Install mysql-connector-odbc-5.2.6-win32.msi
Submitted: 18 Oct 2013 19:52 Modified: 31 Mar 2014 11:01
Reporter: Scott Harmon Email Updates:
Status: Verified Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.2.6 OS:Microsoft Windows (XP)
Assigned to: Bogdan Degtyariov CPU Architecture:Any
Tags: crash, installer

[18 Oct 2013 19:52] Scott Harmon
Description:
When I try to install the msi on windows xp I get an error:

Error 1918.Error installing ODBC driver MySQL ODBC 5.2 ANSI Driver, ODBC error 13: Could not load the setup or translator library. Verify that the file MySQL ODBC 5.2 ANSI Driver exists and that you can access it.

Abort                       Retry                  Ignore

Version 5.2.5 installs fine on the same machine.

How to repeat:
Try to install 5.2.6 on windows xp
[18 Oct 2013 20:22] Miguel Solorzano
Driver Installed on XP

Attachment: odbc_installed.png (image/png, text), 97.27 KiB.

[18 Oct 2013 20:23] Miguel Solorzano
Thank you for the bug report. I couldn't repeat on XP Home Edition (see prior attached picture)
[18 Oct 2013 22:28] Scott Harmon
Install Failure

Attachment: mysql-odbc-install.png (image/png, text), 9.88 KiB.

[18 Oct 2013 22:30] Scott Harmon
If you would like any more info, or for me to try anything else, let me know.
This is windows xp professional.
[22 Oct 2013 17:11] Miguel Solorzano
Open again because was reported by another user, so some issue exists.
[22 Oct 2013 17:14] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=70690 duplicate of this one.
[23 Oct 2013 9:00] andrew turnbull
This seems to be on windows 2003
[25 Oct 2013 9:11] Bogdan Degtyariov
Andrew,

as a workaround you can use the no-install zip package with myodbc-install.exe utility to register the driver.
[25 Oct 2013 9:57] Bogdan Degtyariov
Hi Scott,

The MySQL Connector/ODBC package might refuse to install if some other 3rd party software created an incorrect record in the registry node responsible for ODBC drivers.

In order to check that we would need to take a look at your registry.
Please perform the following steps:

 1. Click "Start" button on the Windows task bar and select "Run..."
 2. Type regedit and click OK
 3. In the left part of the Registry Editor window open the following node:

   My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC

 4. Right-mouse click on ODBCINST.INI key and select "Export" in
    the pop-up menu
 5. Save the file as *.reg (it will not contain any critical information such
    as host names, logins, etc. There will only be the list of the ODBC
    installed in the system)
 6. Attach the .reg file to this bug report (you can also make it invisible
    to public by selecting the appropriate privacy option)

I am looking forward to receiving your feedback.
Thanks.
[29 Oct 2013 11:32] andrew turnbull
PLEASE PLEASE just tell me what it is trying to do so I can do it manually. I tried reading install.bat from the zip install but gave up.

Why does 5.2.5 install with no problems?
[29 Oct 2013 11:34] Bogdan Degtyariov
Hi Scott,

Thank you for providing the registry fragment.
I see it has two entries that indicate the presence of MySQL ODBC Driver:

MySQL ODBC 5.2 ANSI Driver
MySQL ODBC 5.2 Unicode Driver

What versions are these drivers 5.2.5 or 5.2.6?
Do the actual driver files exist in the install directories? In other words, do you see anything if run the following command in the command line?

dir "C:\Program Files\MySQL\Connector ODBC 5.2"
[4 Nov 2013 13:51] Julio Ferreira
Hola Scott: Tuve tu mismo problema (igualito) y luego de mucho...accedi a una pagina que dice que el problema es que no tenia el archivo msvcr100.dll en C:\windows\system32 (yo tuve que buscarlo en intenet ...bajarlo....instalarlo)..

Y WOW!...ahora...funciona, todo Ok.

Good Luck...brother...
[7 Nov 2013 16:14] andrew turnbull
This appears to sometime be caused because msvcr100.dll is not installed. 5.2.6 installer must have been built with a newer version of VS than 5.2.5
[11 Nov 2013 5:55] Bogdan Degtyariov
Thank you very much for confirming the issue with MS runtime library.
Setting the bug status to Verified.
[22 Nov 2013 13:38] Sam Kimmel
So is there a pre-requisite we need to install prior to installing the ODBC 5.2.6 driver?
[5 Dec 2013 17:25] Sue J
I would like to confirm that a user of my software package has also encountered the same problem running Windows XP Professional.
[11 Dec 2013 20:22] John Skolits
I am having the same issue. When performing a manual install, using the "no-install" version, get error:  "...MSVCR100.dll was not found."

There is no C:\Program Files\MySQL folder on my C drive. Also MySQL is not in the registry. 

I'm installing version 5.2.6.

Only difference is I'm loading it on a virtual machine using Windows XP mode on a windows 7 machine. Although, I don't believe that would make a difference.

Have you come up with a solution?
[11 Dec 2013 23:37] John Skolits
I just attempted to do an install of 5.2.6  on a different PC, same problem.
I then tried an older version I had. I used version 5.1.6. The installation was successful. So there is a bug in the current release.
[11 Dec 2013 23:47] John Skolits
Note: I also just tried Version 5.2.5 and it also works, but 5.2.6 does not. I'm fine with using 5.2.5.
[12 Dec 2013 17:04] Sue J
We have found that installing Microsoft Visual C++ 2010 redistributable (32 bit) on our clients machines lets them install the newer versions of MySQL ODBC Connector (5.1.13 and 5.2.6).

This product is mentioned as being a pre-req for MySQL Workbench.
It would seem it is also a pre-req for these newer versions of the ODBC connector.
[14 Dec 2013 14:16] ZEBU GRAND
I am having the same issue. I try on several computer (XP pro, french) and the bug is only on some machines  (I don't make all Windows updates since SP2)
GZ
[22 Jan 2014 10:33] Bogdan Degtyariov
Considering the real solution (install VC redistributable) we can lower the
severity of this bug.
[12 Feb 2014 18:42] Nick Woolley
I have the same error if I run mysql-connector-odbc-5.2.6-winx64.msi on Windows7 SP1, installing Microsoft Visual C++ 2010 redistributable makes no difference. Installing the 32 bit version causes no error message but If I open Data Sources(ODBC) there are no drivers listed for mysql (nothing for mysql in registry either in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers.

MySQL Workbench 5.2 CE was previously installed and this connects to remote databases fine. I've tried copying C:\Windows\System32\msvcr100_clr0400.dll to C:\Windows\System32\msvcr100.dll but it appears to make no difference. 

Also tried installing mysql-connector-odbc-5.2.6-win32.msi on Windows Vista which gives the same error.
[13 Feb 2014 0:51] Bogdan Degtyariov
Nick,

Thank you for your response.

The default ODBC Administrator in 64-bit Windows OS is a 64-bit executable file odbcad32.exe located in Windows\System32 directory. Therefore, it will not show you 32-bit drivers. Make sure you start the 32-bit version of ODBC Administrator from Windows\Syswow64\odbcad32.exe.

Also, the registry node you mentioned (HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers) lists only 64-bit drivers. If looking for a 32-bit ODBC driver you should be checking HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers

The above comments were for Windows 7.
The problem is that we cannot repeat the issue on any of our working/testing/building hosts. Perhaps you could provide us with more details.

Can you please check if the system logged any details (such as missing DLL) in the Event Viewer (you can run it by typing eventvwr in the command line). If there is anything it should be marked as an error into "Windows Logs -> Application" section of the Event Viewer.
Thanks.
[13 Feb 2014 14:43] Nick Woolley
Thanks for the quick and detailed response. On the Win7 64bit PC I confirm that the MySql ODBC drivers were indeed listed in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC both ANSI and Unicode, and I was able to create an ODBC data source using odbcad32.exe. 

For the Windows Vista PC the Event Viewer has the following error:

Product: MySQL Connector/ODBC 5.2 -- Error 1918.Error installing ODBC driver MySQL ODBC 5.2 ANSI Driver, ODBC error 13: Could not load the setup or translator library. Verify that the file MySQL ODBC 5.2 ANSI Driver exists and that you can access it.
[15 Feb 2014 20:23] Alexander Støhle
I can report the problem on Windows Server 2012 R2 Standard core (minimal GUI). Tried to copy c:\Windows\SysWOW64\msvcr100_clr0400.dll to c:\Windows\SysWOW64\msvcr100.dll (Bug #71547) without luck. Event Viewer reports:

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.
[15 Feb 2014 20:37] Alexander Støhle
Installed Microsoft Visual C++ 2010 Redistributable Package (x64)and everything is okey.
[18 Feb 2014 13:47] nicola riolini
I resolve on my Win 2003 server 32 bit installing, before install odbc driver, this collection of DLL:

http://www.microsoft.com/download/en/details.aspx?id=5555

(that's because the driver use MSVCR100.dll )
HTH someone
[10 Mar 2014 14:20] Dean Archer
Thanks Nicola. I was having this issue on one of our Windows Server 2003 machines and your solution worked perfectly.
[12 Mar 2014 15:08] IT Support
I fixed this error by installing the Visual c++ runtime http://www.microsoft.com/en-us/download/confirmation.aspx?id=5555
[19 Mar 2014 8:45] Andy Allen
I also solved this problem by installing microsoft visual c++ 2010 redistributed.yeah,thank god.What a hard day.
[24 Mar 2014 10:02] Lorenzo Coronati
My 2 cents: I had this problem on a newly installed Win7 64bit; my workarond was to copy the msvcr100.dll from Windows\System32 to Windows\SysWOW64.
Then it worked
Lorenzo Coronati
[31 Mar 2014 11:01] Bogdan Degtyariov
Unfortunately, due to licensing matters we cannot include the VC++ redistributable package into the ODBC driver installer.

It will be documented. In addition the documentation will provide the download link for the VC++ redistributable package on the Microsoft web site.
[4 Aug 2015 19:12] Shakeel Mir
i am using Window server 2008 R2 and i am trying to installed the mysql-connector-odbc-3.51.30-winx64 and getting error 1918 error installling ODBC driver mySQL ODBC 3.51 driver ODBC could not be loaded due to system error code 126. the specified module could not be found ...\myodbc3s.dll..
[25 Nov 2015 9:37] Christophe LE GOFF
I had the same problem.
I tried installing redistribuable visual c++ 2010 with no luck.
Then I fully removed mysql from my computer. After that I started digging into Windows Registry searching for "mysql".
I finally found that there was a "mysql ab" folder that could not be displayed due to errors. I deleted it and re-ran the installation. It worked!!
[20 Jan 2016 16:00] Raheel Chaudhry
[SOLVED] Encountered same error 13. Installed Visual C++ 2010 Redistributable as suggested on this board.  Reinstalled ODBC driver. No errors encountered.
[4 Apr 2016 14:26] Andrea Carolfi
MySQL ODBC Installer error

Attachment: MySQL ODBC Installer Error.png (image/png, text), 9.30 KiB.