MySQL Bugs: #70661: Cannot Install mysql-connector-odbc-5.2.6-win32.msi

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:	Windows (XP)
Assigned to:	Bogdan Degtyariov	CPU Architecture:	Any
Tags:	crash, installer

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

Driver Installed on XP

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

Thank you for the bug report. I couldn't repeat on XP Home Edition (see prior attached picture)

Install Failure

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

If you would like any more info, or for me to try anything else, let me know.
This is windows xp professional.

Open again because was reported by another user, so some issue exists.

http://bugs.mysql.com/bug.php?id=70690 duplicate of this one.

This seems to be on windows 2003

Andrew,

as a workaround you can use the no-install zip package with myodbc-install.exe utility to register the driver.

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.

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?

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"

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

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

Thank you very much for confirming the issue with MS runtime library.
Setting the bug status to Verified.

So is there a pre-requisite we need to install prior to installing the ODBC 5.2.6 driver?

I would like to confirm that a user of my software package has also encountered the same problem running Windows XP Professional.

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?

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.

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.

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.

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

Considering the real solution (install VC redistributable) we can lower the
severity of this bug.

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.

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.

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.

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.

Installed Microsoft Visual C++ 2010 Redistributable Package (x64)and everything is okey.

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

Thanks Nicola. I was having this issue on one of our Windows Server 2003 machines and your solution worked perfectly.

I fixed this error by installing the Visual c++ runtime http://www.microsoft.com/en-us/download/confirmation.aspx?id=5555

I also solved this problem by installing microsoft visual c++ 2010 redistributed.yeah,thank god.What a hard day.

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

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.

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

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!!

[SOLVED] Encountered same error 13. Installed Visual C++ 2010 Redistributable as suggested on this board.  Reinstalled ODBC driver. No errors encountered.

MySQL ODBC Installer error

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