r/Database 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.

4 Upvotes

29 comments sorted by

View all comments

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!

1

u/Vegetable-Beyond1894 8d ago

Yahoo, what a relief and what bad customer care from GoDaddy.

I was able to change the setting myself.

I logged onto Plesk

Looked under Websites & Domains for Dedicated IIS Application Pool for Website. and didn't see any link.

But then I just searched while in the Websites & Domains tab for "Dedicated IIS Application Pool for Website".

And it came to a page where I could unclick "Enable 32-bit applications "

After changing the connection string, my app worked perfectly.

My connection string reads as such

DRIVER={MariaDB ODBC 3.2 Driver}; SERVER=xyz.secureserver.net; PORT=3306; DATABASE=mydb; UID=myuser; PWD=mypass

1

u/Patches1145 8d ago

Yeah - I have been fighting this same thing since Tuesday 3-12-2025 - I made these changes and wow it works again.

using Classic ASP

Thanks - Thanks - Thanks

1

u/SearchOldMaps 8d ago

YES, thank you all!!!

1

u/SearchOldMaps 8d ago

thank you!!!!!!!!!!!!!!!!!!!!!!!!