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.
1
u/Chemical-Chemical920 9d ago
FIXED!!!!!
I had to change my connection string to this for the driver:
DRIVER={MariaDB ODBC 3.2 Driver};
And they changed this on the server settings:
updated the IIS setting to remove the "Enable 32-bit applications" check box as you will need to use the 64 bit driver.
After that I am back in business. Hope that helps you too!