Connection error - VBA/MySQL

Trying to connect to a remote, hosted database from VBA.  Worked at one time.

Using this connection string:

con.ConnectionString = "DRIVER={MySQL ODBC 5.2 ANSI Driver};" & ";" & " DATABASE=xx;" & "UID=xx;PWD=xx; "

I'm getting the error below.  Again, this is a hosted site.  I don't think I have total control to just modify users.

mysql connection using old (pre-4.1.1) authentication protocol refused
Who is Participating?
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
Is the host Hurricane Electric?  I have that problem with them because they have kept the old authentication methods to 'avoid breaking old web sites'.  Worse yet, I just downloaded the MySQL 5.2 ODBC connector and it removed the MySQL 5.1 ODBC connecter and broke my code in several files.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
I would also recommend checking with support for the hoisting providers to see if anything has changed.

I also use this for managing remote mySQl Servers:  It can be used to test your connection.
patriotpacerAuthor Commented:
>>Is the host Hurricane Electric? - trying to help out a friend on this one.  I think they upgraded their servers.


link not loading
7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
The link you posted worked for me.

Try a web search for heidisql to see if that will provide a link will work for you.
patriotpacerAuthor Commented:
I went back to an older driver.  All working.

I guess I made the assumption the latest MySQL driver would work.

I appreciate the comments and help
patriotpacerAuthor Commented:
I'm accepting answers because (1) nothing had changed and required the old driver and (2) the statement below gave indication that an issue might be the new driver and resort to the old.

>>MySQL 5.2 ODBC connector and it removed the MySQL 5.1 ODBC connecter and broke my code in several files.
Dave BaldwinFixer of ProblemsCommented:
Thanks for the points.  I sent an email to Oracle/MySQL complaining about the new driver breaking the old one.  All I got back was an automated response.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
About the ODBC driver 5.2.x, you need to be sure you use the correct bit version.

The key is whether your ODBC client application -- the software that's going to use the data -- is it 32-bit or 64-bit.

Since Windows 7 64-bit  supports both 32-bit and 64-bit applications. 32-bit applications can only use 32-bit drivers; 64-bit applications can only use 64-bit drivers.

You need to match the bits of the driver to Office/Access 32 or 64 bit, not the version of Windows.

Office/Access 2010/2013 64 bit needs the 64 bit Driver

Office/Access 2010/2013 32 needs the 32 bit Driver.

Office/Access 2007 and earlier need the 32-bit version.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.