Hello!

Any help would be greatly appreciated!

Thanks in advance!

Background
Our web site obtains case numbers and names from users, calls some VB ActiveX DLLs to query the database, and displays information back to the user. The data is a combination of FoxPro 2.x tables and a VFP database (DBC). The DLLs use ADO to query the tables. All DLLs are running under MTS (Component Services) on Windows 2000 Server. The web site uses Active Server Pages.

Problem
The web site hangs after several hours of use. When I go into the Microsoft Management Console and view the components in the Status View, the Call Time (ms) is incrementing and never resetting, eight objects (it is always eight) are in call and activated for the DLL querying the tables, and the other components have active objects (but the numbers vary). To resolve the problem, I shutdown the application (right-click on the application), and all is well again.

Steps I have taken
The latest ODBC driver is installed as well as any critical updates to the Windows 2000 server. I have explicitly destroyed any COM object created (set object = Nothing) in the DLL and ASP. All ADO recordsets are explicitly closed and destroyed.

Design
The web site uses a three-tier approach to query the data. The ASP is the Presentation Layer (PL) and two VB DLLs serve as a Business Logic Layer (BLL) and a Data Access Layer (DAL). A disconnected ADO recordset is passed as a parameter from the PL to the BLL. Inside the BLL, another recordset is created from business rules being applied to PL recordset. The BLL recordset is sent to the DAL which in turns queries the data. A DSN entry is created on the fly, and the VFP ODBC driver is invoked.

The ADO recordset created from the query is returned to BLL. The BLL applies business rules to DAL recordset and creates another recordset to pass to the PL. The PL the displays information on the web page.