Microsoft KB Archive/253449

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

Article ID: 253449

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft Data Access Components 1.5
 * Microsoft Data Access Components 2.0
 * Microsoft Data Access Components 2.1
 * Microsoft Data Access Components 2.1 Service Pack 2
 * Microsoft Data Access Components 2.1 Service Pack 1
 * Microsoft Data Access Components 2.1 Service Pack 2
 * Microsoft Data Access Components 2.5
 * Microsoft Data Access Components 2.6
 * Microsoft Internet Information Server 3.0
 * Microsoft Internet Information Server 4.0
 * Microsoft Internet Information Services 5.0

-



This article was previously published under Q253449



SYMPTOMS
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:

ASP 0115 A trappable error has occurred

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



CAUSE
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 that are indicated in the following Knowledge Base article:

193225 How to Configure IIS to Connect to Oracle from ASP and ADO

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:

http://msdn.microsoft.com/dataaccess

This behavior is by design.



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

 Look at the entries for the SQL*NET Client (Oracle Net 8 Client for Oracle 8) and the Required Support Files (RSF). The entry should have one of the versions that are indicated in the following Knowledge Base article:

193225 How to Configure IIS to Connect to Oracle from ASP and ADO



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.

