>>The web site hangs after several hours of use.
>
>I don't know if it's related to your problem, but here is a knowledge base article about the VFP ODBC driver and connection pooling:
>
>
http://support.microsoft.com/support/kb/articles/Q229/1/00.ASPHi David!
I came across the article the other day. I checked the registry, and connections are
not pooled. Do you know if there is any limit to the number of active connections allowed to a FoxPro table?
I was just watching the MMC, and I saw the active object count shoot up from zero to eight. This caused the web site to hang. I checked the log files (W3SVC1), and there were at least eight separate queries within a minute. It seems like every time it hangs the number of active object is always eight.
Thanks for your help!
Tim