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.

tia for any thoughts on the matter

Paul Emery
oakgrove@lansing.com