MySQL from remote server: Catastrophic Error

[Spork52]

My ASP website connects to a remote MySQL server like this:

connectstring = "Driver={MySQL ODBC 3.51 Driver}; Server=myserverip; Port=3306; Database=mydbname; USER=myusername; PASSWORD=mypassword;"
Set objConn = Server.CreateObject("ADODB.Connection") 
objConn.Open(connectstring)

After working fine for more than two years, the server now says:

Provider error '8000ffff'
Catastrophic failure

whenever I try to make a DB connection.

I have not changed any code for weeks.

I can connect to the DB from the local webserver (same host as MySQL, "localhost' in connection string, with PHP) and from my desktop using DB management software.

Both the web host and the mysql host claim that they have changed nothing and that there have not been any server problems.

 

[Spork52]

Additional info:

I tried connecting from a different host and got this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver]Client does not support authentication

That host says they have version 3.51.16 of the ODBC driver installed and that it's supposed to work with MySQL5. I WAS able to connect from two sites hosted by the same company that hosts MySQL (version 5). They are using version 3.526.3959.0

 

[azzazzello]

Hmm....you are connecting to a MySQL 5 server with a mysql 3 client? I dunno...sounds fishy. There may have been changes in how authentication is done. How about upgrading the ODBC driver?