My ASP website connects to a remote MySQL server like this:
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.
Code:
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)
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.