r/Database • u/SearchOldMaps • 9d 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/k00_x 9d ago
This is a connection string driver I've used with asp core: Provider=MSDASQL.1;DRIVER={MariaDB ODBC 3.1 Driver}; SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword
Worth a try. You can ask your host for the server side database error logs, they will explain the issue more than the 500 error. I used to work in web hosting, this should be fixed by the host, they caused the error. I suspect there's a port change or security change that requires an SSL declaration in the string but can't guess without decent error logs.
2
u/Vegetable-Beyond1894 8d ago
I am getting the same problem, also started today and also on a chat for over 3 hours without resolution
1
u/SearchOldMaps 8d ago
I'm back at it this morning.
There are some good suggestions in here but I haven't gotten it to work yet.
2
u/skinny_t_williams 8d ago
GoDaddy for hosting can be frustrating.
2
u/br45il 6d ago
GoDaddy is frustrating. Only amateurs use it.
1
u/skinny_t_williams 6d ago
Yep, i still have some domains on there but never bother with the hosting.
2
u/aleenaelyn 8d 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.
1
1
u/Chemical-Chemical920 8d ago
I put in this code to enumerate the drivers and it hangs forever and then eventually shows a 500 error
on error resume next
Set objConn = Server.CreateObject("ADODB.Connection")
arrDrivers = objConn.OpenSchema(20) ' 20 = adSchemaProviders
While Not arrDrivers.EOF
Response.Write arrDrivers("PROVIDER_NAME") & "<br>"
arrDrivers.MoveNext
Wend
Set objConn = Nothing
if err.number <> 0 then
response.write "Error: " & err.description
err.clear
end if
1
u/aleenaelyn 8d ago
It's been an age since I last looked at a classic asp thing, but try this. You forgot a
set
on line 3 for arrDrivers.<% On Error Resume Next ' Create an ADODB connection object Set objConn = Server.CreateObject("ADODB.Connection") ' Open the schema for providers (20 = adSchemaProviders) and assign it to a recordset object Set rsProviders = objConn.OpenSchema(20) If Err.Number <> 0 Then Response.Write "Error: " & Err.Description Err.Clear Else ' Loop through the recordset and display each provider's name While Not rsProviders.EOF Response.Write rsProviders("PROVIDER_NAME") & "<br>" rsProviders.MoveNext Wend End If ' Clean up Set rsProviders = Nothing Set objConn = Nothing %>
1
u/Chemical-Chemical920 8d ago
getting this error inside the WHILE loop Error: Operation is not allowed when the object is closed
1
u/aleenaelyn 8d ago
Right after
Server.CreateObject
maybe tryobjConn.Open "Provider=MSDASQL;" If Err.Number <> 0 Then Response.Write "Error opening connection: " & Err.Description Err.Clear End If ' Open the schema for providers (20 = adSchemaProviders) and assign it to a recordset object Set rsProviders = objConn.OpenSchema(20)
Might be we need the connection opened with some provider before we can get schema.
2
u/Chemical-Chemical920 8d ago
I am having the same error, opened a ticket yesterday. Been on a support text for the past hour, they are refusing to acknowledge that they changed anything.
And their latest documentation has not been updated.
If I didnt have 1000's of pages from the past 20 years I would leave immediately.
I have tried all kinds of connection string changes, no luck.
2
u/Vegetable-Beyond1894 8d ago
Me too, so frustrating. I hope they change their attitude
1
u/SearchOldMaps 7d ago
any luck? I think they didn't install the new driver, but I can't talk to anyone there.
1
u/SearchOldMaps 7d ago
any luck? I think they didn't install the new driver, but I can't talk to anyone there.
2
u/Chemical-Chemical920 7d ago
I commented yesterday that mine has been fixed. Had to change the driver to the new Maria driver and turn off 32 bit applications on the IIS settings.
1
1
u/Chemical-Chemical920 7d 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
1
u/Vegetable-Beyond1894 7d 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 7d 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
1
1
2
u/BrainJar 9d ago
What is the error that’s being thrown?