Microsoft KB Archive/236019

= PRB: ASP Application Using ADO with Visual FoxPro ODBC Driver Crashing IIS =

Article ID: 236019

Article Last Modified on 10/23/2003

-

APPLIES TO


 * Microsoft Internet Information Server 4.0
 * Microsoft Active Server Pages 4.0

-



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 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.

Keywords: kbdatabase kbprb KB236019

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.