A client of mine recently switched to a new webhosting account so we're in the process of restoring their website for them. Their website was built in ASP and depends on a small SQL database for some information. I've restored all data to the new host, and created a new SQL database to restore that to. The account is with 1and1.com, so anyone familiar with their setup will know that they assign you a database name, user and password and you can't alter this information.
Now, after I imported my SQL backup (something.bak) into the new database, it looks like the tables and data are all there but after updating the settings in my main ASP page, I get an "HTTP 500 - Internal server error" when trying to navigate to, lets say: http://xxyyzz.com/products.asp?catCode=TP
I edited the below info in products.asp; no other files I found contained any reference to a database so I guess this is the only one I need to change.
1) Does the "PROVIDER=" field need to be changed from "SQLOLEDB" to something else?
2) There were some other lines like this one in the same page that had "connectstring=..." but they began with an apostrophee, I gather that means that those lines were commented out and were probably for older setups?
3) When browsing through 1&1's SQL Light viewer, or something like that, I see that the userid for all the tables and such is still "oldUSR" (the username from the old DB setup) instead of "user22222" from the new DB. Could this be causing the issue?
Thanks very much in advance!