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

• Microsoft Internet Information Server version 4.0
• Active Server Pages

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.

Additional query words:

Keywords : kbADO kbODBC kbVFp
Version : winnt:4.0
Platform : winnt
Issue type : kbprb