Hi, been away for quite a while, been concentrating on my photography now my website is up and running. However, I needed to change the value in a field on my database, so before submitting to web I chnaged it and tested locally through IIS. Let me start by saying that the field change is not the problem, it was simply increasing a numerical value from 20 to 25. A downloaded copy of the db running my website, in the state prior to changes being made, at the moment from the webhost creates exactly the same problem.

The problem? When I test my site in IIS any ASP page I select is showing only the code and not the page itself. I've tried restarting IIS but this has had no effect. Only html pages will run. The ASP pages on my website are displayed correctly when I surf them so it makes me think it's not a generalised browser (Firefox) problem, but exclusively IIS or a combination of browser/IIS.

Any help please?

Thanks, Lol

This is an IIS issue specifically (i.e. it doesn't have a thing to do with the browser).

First, make sure your permissions on the site are set to Read/Run Scripts (the latter is the key one).

Second, check Web Server Extensions and make sure that ASP is Allowed on your server.

One of the two of those (I suspect the former) will solve your problem.

Good question, though, dude...it actually requires thought to solve it.

Thanks Adam, is this where I should be looking?

http://i31.photobucket.com/albums/c3...Lol/Image2.jpg

If so is everythging set okay?

Cheers, Lol

That's the one spot, and everything looks okay on the service.

Now check under Web Service Extensions and see if ASP is explicitly set to "Allowed".

Could you idiot talk me through that one please? I can pull up the IIS Manager but get a bit lost after that. I'm running XP Pro.

Thanks, Lol

Okay...when you pull up IIS Manager, you should see three folders:

1) Application Pools
2) Web Sites (where you're looking now)
3) Web Service Extensions

Open up the Web Service Extensions folder, and you'll see a list of the service extensions (ASP.Net, ASP, PHP, etc.) that are allowed and not allowed.

You might have to add ASP to that list, if it's not there, but if it's there, just Allow it.

Right, this is all I have I don't see some of what I should do!

Weird...your server is radically different from mine.

I don't know what to tell you from here on out, except possibly to right-click on "HOMELOL", click "Properties", then "MIME Types" and see that ASP is in there as a mime type (.asp is the extension, application/x-asp is the MIME type).

After that, I got nothing.

No problem mate. Thanks for your help anyway.

IIS5 on Win2K pro.

On the Directory tab (as shown in post #3) click the Create button to set up and start the application.

Hi Chris, this is what I have after selecting "Create". Unfortunately the asp pages still don't run.I noticed the Starting Point is set to Default W... Is this pointing to a web address or on my IIS? Does it need changind and if so how?

Thanks, Lol

Hmm, seems I was not typing in the file path correctly in the Run dialogue box. Now I'm NOT opening the page as a file but as a webpage I get the following screen, but have no idea on how to correct it:

The good news is that it's executing ASP code. The bad news is that you have a script error.

It looks like the database is either opened up offline or that you haven't got permissions on the folder itself.

Hi Adam, it looks to be a permissions thing, although why this should have changed I can't imagine. Whereabouts do I alter this please?

Thanks, Lol

Check the "Write" box in that second screen cap.

Hi Adam, I've checked "write" but it's still the same. In operation the database isn't written to, only read from if my understanding is correct. It is used to hold file paths to iumages for a db driven "slideshow" so no actual writing to is necessary?

Thanks, Lol

Is it a Access database? If so you need write or full control over the folder it lives in. Every time you open a mdb file (even in code) it creates a ldb file, then deletes this when the last user closes out.

Yeah it's Access and I've crossed swords with rogue .ldb files before. I've done a full system search for .ldb files and found none. I've set full permissions on the folder with the database in and still nothing. I give in. Thanks everyone for all their help.

Cheers, Lol

The same error can also be caused by the db not being found in the folder the code is looking in.

One problem may be the starting point for the application being one folder down from root.

Move the default web site home directory to the root folder for your site, then you can use /localhost/ instead of /localhost/17minutes/ which could mean you have to recode some things when you upload to your production server.

Looking at the error the access database you are using is locked out by the previous action , you may want to see if the datbase is accessible in the access front end, if it does, you can very well close the application and try it.

If access front end says it is in use by another user, just restart the IIS service and it should be able to release that connection.

Then attempt to use that database is access front end. If you still can't open it, then you may need to find any other application is sharing the same database.


If non works, reboot the box and try and even if it doesn't work, override the the database with a backup.