>I use classic ASP pages with ado and odbc sql queries to several VFP free tables on a windows 2000 (servpak3) server running iss. It has been running for several years with few problems. This box runs numerous web sites several of which query the datatables.
>
>Occasionaly something occures that causes the .asp pages to not be able to load. Html pages load ok. I have to stop and start IIS to clear this problem. I can't reproduce the error and there are thousands of users hiting the pages all day long. Does anybody have any ideas on how I might start looking for the cause. Is there any way to 'trap' for events that might be causing this.

So, it seems that the cause is applicable when the ASP query code takes place. Basically, the page stops loading because something happens on the ODBC query line, right?

What is the ASP error message coming in exactly? Is there any?

Also, have you found any relation with those situations about the parameters of the ODBC query such as a very long query or it doesn't matter at all?