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


The information in this article 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 (GA)
  • Microsoft Data Access Components 2.1 SP1
  • Microsoft Data Access Components 2.1 SP2
  • 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.

REFERENCES

194190 PRB: ASP 0115 a Trappable Error Has Occurred

193941 INFO: Location of Oracle's Public FTP Site

Modification Type:MinorLast Reviewed:11/3/2003
Keywords:kbOracle kbprb KB253449 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.