"The requested resource is in use."

And the Cache ISAPI Applications box IS checked on my server

[woop01]

Does anybody have experience with this error and what cuases it? Every now and then it shows up every time one of my users tries to access an ASP page.

[wardbekker]

Does your webapp connect to an access database? i've had some issue's with that. Rebooting IIS solves it most of the time. Also explicitly close all opened resources from your asp script, always a good practice

[woop01]

Thanks for the input. Unfortunately, I think it's a little bit more 'advanced' problem than what you assumed.

Does your webapp connect to an access database?

No, it's connecting to an SQL 7 database on another dedicated Win2000 server.

Rebooting IIS solves it most of the time.

Actually, it's helped every time so far. Unfortunately, this tends to happen when I'm away and don't notice it until I get back to a computer. With a 4 million page view per month (9M hit) site, it tends to upset a few people.

Also explicitly close all opened resources from your asp script, always a good practice

I've gone back through and checked each and every page for the "rs.close" and "set rs = nothing" and made sure they all have it. Unfortunately, it hasn't helped.

I really don't think it's a basic level ASP problem (aka, write descent code and use a descent database) but I may be missing something.

[wardbekker]

did you also close the connection object? and when this occures, did you checked the error log. Maybe you should stress-test your webapp a bit. Microsoft has a nice tool for that

[woop01]

Yes, I close both the connection and the record sets on all 300+ pages.

[wardbekker]

On the ASPfaq.com website you can find out more about this error: http://www.aspfaq.com/show.asp?id=2356