Oracle Query or Stored Procedure from ASP and ADO Causes IIS to Stop Responding

When issuing a query against an Oracle database or calling an Oracle procedure from an Active Server Pages (ASP) application, the following may occur:

• The service (WWW service) may stop responding to requests for the ASP pages.
• The service may shut down.
• The failing ASP page may return with the following error message:

This behavior may not occur unless multiple clients are accessing the Web site simultaneously.

This behavior occurs because the version of the Oracle client networking components that are installed is not fully compatible with the IIS computer. Because the IIS computer is a multithreaded environment, there are version requirements for the Oracle components. When you connect to Oracle from ASP applications that run under the context of the IIS computer, you must run the version (or a later version) of the Oracle client components

In addition, Microsoft recommends that you install the latest version of Microsoft Data Access Components (MDAC). You can obtain the latest version of MDAC components from the following Web address:

This behavior is by design.

When you install the Oracle client components on the IIS computer, the Oracle installer logs the version of the installed components to the Nt.rgs file in the Orant\Orainst folder. To determine the version of the Oracle client components that are running, do the following:

• Open the Nt.rgs file.

Customers encountering this behavior should work with their Oracle database administrator (DBA) or with Oracle to obtain and install the necessary patches to configure the IIS computer to connect to Oracle from ASP.