Connecting to remote MySQL db in Classic ASP

[pixuk]

Hi All,

I'm trying to connect up to a remote MySQL database (not on Jodohost) from a Classic ASP page (which is on Jodohost).

My googling of the problem, including through these support forums, seems to suggest the following connection string is the one to use:

"Driver={MySQL ODBC 3.51 Driver};server=[IP ADDRESS];uid=[USER];pwd= [PASSWORD];database=[DB NAME];Option=16387;"

However, when I run that I get the following error;

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client

Should I take this on face value that the client on Jodohost is out of date, or do I need a different connection string? The MySQL database I'm connecting to is 5.0.81 (protocol version 10). I'm using the ADODB.Connection object method - is that also correct?

Pete

[Stephen]

We are using the older authentication so that people can connect to the both MySQL servers in our network.

[pixuk]

Is there a connection method from Jodohost to use the current/new authentication? A different driver, perhaps?

[Stephen]

Originally Posted by pixuk

Is there a connection method from Jodohost to use the current/new authentication? A different driver, perhaps?

I will check it and reply within 24 hours. I know in ASP.NET, yes. ASP, I am not as sure of myself.

[Stephen]

I need a bit longer, have had some short phone calls that went long here today so far....

[Stephen]

Looks like we can run them side by side, for the 5.1 version, please let me know which server you are on.

[pixuk]

Hi Steven,

Thanks for this - I'm on win19

Pete