>As I said, I can't make the problem happen. I do think it has something to do with retrieval of cursors from the dbf files. Once the ASP pages have stopped loading there is no error message. The browser just times out. I have tried to look at the system error logs but I don't see any thing there that seems to be related.
The browser will time out based on the server params. You may try to increase the IIS server time out for a while to see if you'll run into the situation.
Then, you'll be able to see as per the frequency of now based on this new setting. If it's about the same, and you have increased the IIS timeout by a large number, then, it won't probably be not related to the query itself but to an external factor such as server memory and such.
If your request load higher than it used to be? Any additional components running on the server since you started to have this problem?