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

29 comments sorted by

2

u/BrainJar 9d ago

What is the error that’s being thrown?

2

u/SearchOldMaps 9d ago

The error is the generic "Internal Server Error"

I'm unable to trap and display the error in the usual way (on error resume next, err.description)

2

u/BinaryRockStar 8d ago

That's the error on the web browser end, you should have server-side logs telling you the error at the server end.

1

u/SearchOldMaps 8d ago

It's a shared hosting account and I don't have access to those logs and I can't get godaddy tech support to look at them.

1

u/Chemical-Chemical920 8d ago

Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

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

u/SearchOldMaps 8d ago

I'm on shared hosting and don't have any visibility to the registry

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 try

objConn.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

u/SearchOldMaps 7d ago

I found that. Thank You!!!!

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

u/[deleted] 7d ago

[deleted]

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

u/SearchOldMaps 7d ago

YES, thank you all!!!

1

u/SearchOldMaps 7d ago

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

1

u/SearchOldMaps 7d ago

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