Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL from remote server: Catastrophic Error

Status
Not open for further replies.

Spork52

Programmer
Nov 20, 2007
134
US
My ASP website connects to a remote MySQL server like this:

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)
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.
 
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
 
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top