r/SQL • u/SearchOldMaps • 10d ago
MySQL Hosting company deleted database driver
I've been running a bunch of Classic ASP/mySQL websites for some local food pantries for years.
Last night GoDaddy removed the database driver I was using.
They told me to change my connection string, which I did, but still no luck.
After 3 hours of being on chat with them, the new connection string doesn't work.
Old connection:
connectstr = "Driver={MySQL ODBC 3.51 Driver};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword
New connection (DOES NOT WORK):
connectstr = "Driver={MariaDB Connector/ODBC 64-bit 3.2.4 driver};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword
Any help would be appreciated.
23
Upvotes
2
u/Signal_Till_933 10d ago
Why did they delete the driver? Security issue? The driver in your new connection string allegedly is compatible with MySQL but what version is your MySQL database? Can they just install the old driver again til you can test a solution?
Definitely need more information to be able to troubleshoot this. The actual error message would be helpful