Solved

MySql ODBC connector install error 126

Posted on 2014-02-12
4
4,079 Views
Last Modified: 2014-04-06
When I try to install the MySql ODBC connector I get error code 126. I've tried installing on a 32bit Windows Vista PC and on a 64bit Windows7 PC. On Win7 I've installed the Microsoft Visual C++ 2010 Redistributable Package (x86) and still file myodbc5S.dll is missing.

Also tried copying C:\Windows\System32\msvcr100_clr0400.dll to C:\Windows\System32\msvcr100.dll as suggested here

Anyone got a fix for this please?
0
Comment
Question by:ncw
  • 2
4 Comments
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 200 total points
ID: 39854176
I don't believe the MSFT Visual C++ libraries include the installers for MySQL. Instead, you can download the installers here:

http://dev.mysql.com/downloads/connector/odbc/3.51.html#downloads

5.1 and 3.5 versions are available on that link.
0
 
LVL 1

Author Comment

by:ncw
ID: 39854216
@Scott: Like I say in my question, I've tried to install the Mysql ODBC connector (which yes I did download from the same place as your link) but it fails. The VC package is just a published workaround which has worked for some. I've now added a comment to a bug report.
 
I've already tried version 5.1 which gives the same error, v3.5 installs ok but MySql rejects the authentication method.
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 300 total points
ID: 39854675
I had a similar issue with the .Net connector:

    http://bugs.mysql.com/bug.php?id=66647

Look near the bottom. The solution(!) was to change the password.

/gustav
0
 
LVL 1

Author Closing Comment

by:ncw
ID: 39980979
I'm sorry I've not been able to retest yet, but EE need a response so I've accepted your comment as a solution without knowing whether it works.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help writing a query 6 69
Tags from access to excel 3 24
Close Print Preview button not active 12 35
MS Access 03, TransferText, decimal places 8 35
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now