Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

This article was previously published under Q253449

↑ Back to the top


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.

↑ Back to the top


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

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.

↑ Back to the top


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

↑ Back to the top


References

194190� PRB: ASP 0115 a Trappable Error Has Occurred
193941� INFO: Location of Oracle's Public FTP Site

↑ Back to the top


Keywords: kboracle, kbprb, KB253449

↑ Back to the top

Article Info
Article ID : 253449
Revision : 9
Created on : 11/21/2006
Published on : 11/21/2006
Exists online : False
Views : 391