PRB: ASP Application Using ADO with Visual FoxPro ODBC Driver Crashing IIS (236019)


The information in this article applies to:

  • Microsoft Internet Information Server 4.0
  • Microsoft Active Server Pages
This article was previously published under Q236019

SYMPTOMS

An Active Server Pages (ASP) application that uses ActiveX Data Objects (ADO) with the Visual FoxPro ODBC Driver randomly crashes. This results in Event ID 37 being logged in the Windows NT System Event Log (Source W3SVC Type : Warning <application> terminated unexpectedly).

This issue most often occurs under load conditions when running high volume queries.

CAUSE

The Visual FoxPro ODBC Driver can process queries in the background. This "background fetching" feature, also called progressive fetching or asynchronous fetching, should be disabled if the ODBC driver is being called by a multi-threaded application such as ASP.

NOTE: By default, "background fetching" is enabled, and MDAC 2.1 installs the Visual FoxPro ODBC 6.0a Driver.

RESOLUTION

To resolve this issue, disable the Fetch data in background feature on the IIS server that uses ADO with the ODBC Visual FoxPro ODBC driver :
  1. Run Control Panel.
  2. Select the ODBC Data Source icon.
  3. Select the File DSN tab.
  4. Select the entry matching your Visual FoxPro connection.
  5. Select Configure.
  6. Select Options.
  7. Clear Fetch data in background.
  8. Click OK twice to save the settings.
Modification Type:MajorLast Reviewed:10/23/2003
Keywords:kbDatabase kbprb KB236019
©2003 Microsoft Corporation. All rights reserved.