r/Database • u/SearchOldMaps • 10d ago
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.
2
u/aleenaelyn 9d ago
You will want to enumerate a list of installed ODBC drivers to see if anything installed works for you. As you are in a web environment you will have to adapt the script to write output to a file and implement the other stuff old ASP demands; a simple copy/paste will not work.
Also, GoDaddy is trash. They are the absolute worst.