asked on

ODBC CONNECTION FAILS TO INSTALL...

There are more than 300 EE questions regarding ODBC failure. Goes back to Win 98 and Millenum!

I run Win 7 Pro 64. Have installed ODBC 5.1 for both 64 bit and 32 (MySQL). Have checked the registry, and located files in directories, but have not found a solution.

Is there a solution?

Perhaps that's the best question to ask!

If some Expert (on ODBC and Win 7 Pro) can help, I'll be grateful.

Thanks

Dave Baldwin

You probably want to "Request Attention" and make sure your question is in the right zones. You say ODBC 5.1 MySQL but this is the Microsoft SQL Server 2005 zone.

How are you testing the ODBC connector? I have both 3.51 and 5.1 working on this machine and connecting to MySQL 5 on my website some where on the internet.

cgustaf

ASKER

How do I "Request Attention?"

The ODBC connector fails to connect when the setup Wizzard is run. There are various error codes, most recently 193.

Dave Baldwin

Click on the words "Request Attention" that are below the Question block and above the Answers block. Above the top right corner of my first response.

Dave Baldwin

The 4 things you need to test a MySQL ODBC connection in the Wizard are the IP address (or domain name) of the server, a database name, and a valid username and password with privileges on that database.

cgustaf

ASKER

Thanks -- Yes, the wizzard requests authentication, which I have provided. The one area that is nebulous is "the server." For standard connections to the MySQL databases on the server I use "localhost." This works fine -- but not in the ODBC context. Thus, I do not think the problem lies with the server address, though I have no proof.

Rather, I think there is a problem with installation. Perhaps files are being placed in the wrong directories during installation. Perhaps paths placed in the registry during installation are incorrect.

It's difficult to know what might be wrong.

Dave Baldwin

Instead of 'localhost', use 127.0.0.1 There are some issues with using 'localhost'.

From http://forums.mysql.com/read.php?168,513015,513477 :

Turns out that by default on Win7 machines, localhost resolves to ::1, which is the IPv6 version of the loopback address. You can either connect to 127.0.0.1 instead (could have sworn I'd tested that) or edit the windows hosts file (c:\windows\system32\drivers\etc\hosts) to redefine localhost back to 127.0.0.1

Also, if the MySQL server is running on 'localhost', your local machine, you should be able to go to the command line and type:

mysql -uuser -ppassword

Open in new window

and get into the mysql command line monitor program.

Dave Baldwin

I just reread your last message. If you are trying to connect to a MySQL server on another machine, then you need to use the IP address of that machine as the server name. Unless you have done something to the installation, there is no particular reason to think it's wrong. MySQL is pretty straight forward.

cgustaf

ASKER

I'm checking on something relating to this. The server is reached over the internet. And for operations other than ODBC localhost works.

ASKER CERTIFIED SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Dave Baldwin

membership