Error 500 on classic ASP site

SheppardDigital used Ask the Experts™

I've been passing a website to setup on a development server for a client, the only issue being is that it's in classic ASP, and I have very little in the way of experience with it.

I've got access to a VPS running windows, with sql server express and IIS7 installed, as well

I've created a site, and created a virtual folder, and uploaded the asp files to the site, but when I try to access the site, I get an error saying that there is an error 500 - There is a problem with the resource you are looking for, and it cannot be displayed.

I get no indication of what the problem is.

I've uploaded a test asp file, and it seems to work ok

I'm just wondering if anyone has any ideas. The site does connect to a database, and I think I have it setup correctly, but without an error message I don't really know what the problem is.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You need to disable "ShowFriendlyErrors" in your browser to see the real error.

The next thing is that classic asp is not supported out of the box on IIS7. You need to install the support for it.

For more information take a look here:


In IIS I have an ASP option which lets me select various settings. I've changed it so that it sends errors to the browser, and now I'm getting this...

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

Is this error any more useful?
I've managed to resolve this by changing the data provider to Provider=SQLOLEDB;

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial