ASP Pages Stop Loading

[oakgrove]

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

 

[palbano]

have you looked in the System and Application error logs?

do you have all the latest service packs for IIS and your Database installed? What is your database product?

-pete

 

[oakgrove]

The data source is foxpro dbf files via an ODBC DSN connection. I have looked at the logs but am not very familier with what to look for. Any suggestions on what and where to look?

 

[baddos]

Look in the IIS logs for HTTP error code 500. When you see them, take a look at the page(s) where they are coming from and see if anything looks bad.

 

[oakgrove]

I did look at the logs which lead me to the MS KB.
I think maybe the problem has to do with one or both of two issues with the VFP ODBC Driver. MS KB article Q288863 says the driver should be configured to NOT do background fetching when used with a multi-threaded application such as ASP. It also mentions possibility of the enviornmental variables TMP and TEMP being invalid. The driver uses temp files and if the environmental variable are not functioning problems can arrise from insufficient free drive space.

 

[MegM]

We are having a similar problem (only restarting IIS does not help us) - search for Q297989 either on the MS site or in the IIS forum . . .

 

[oakgrove]

I solved the problem by changing the properties on the ODBC driver. The data being retrieved is in VFP dbf files. I went to the ODBC Data Source Administrator/Options and removed the check mark on 'Fetdh Data in Background'