May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
Course Of The Month
7 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Oracle XE / ASP 115 Trappable Error Help
Posted on 2008-10-14
I am looking for help/advice.
We installed Oracle Express Edition (XE) to a Windows 2003 SP2 server and it works fine through the APEX interface and SQLPlus.
We have set up a web site and use ASP (not .NET) pages, utilizing the ADO object, to connect to the server with almost no problems.
We can use the same page repeatedly to connect, read and update the database, but randomly, we receive this error:
ASP 115 A trappable error (C0000005) occurred in an external object. The script cannot continue running.
We are now working with Microsoft to help us resolve this issue, however, they referred us to this KB article, which sounds like what's happening to us, except there are no *.RGS files found. The .DLL's found in the Oracle_Home\BIN folder are 10.2.0.1.
253449 Oracle Query or Stored Procedure from ASP and ADO Causes IIS to Stop Responding
http://support.microsoft.com/default.aspx?scid=kb;EN-US;253449
We have searched the web, including this forum, and tried everything we found. Obviously we're missing something. We're leaning toward believing there is a problem with this version of Oracle XE and Windows.
I'd like to know if there is anyone who is using Windows Server 2003, SP2 and XE (10.2.0.1) and connecting to XE through ASP using an ADO object? We are using the OraOLEdb10 driver with a TNSless connection string.
If so, I'd like to get some information on your setup to see where we may be different.
Any/All help is greatly appreciated.
Thank you,
Sandy G
We installed Oracle Express Edition (XE) to a Windows 2003 SP2 server and it works fine through the APEX interface and SQLPlus.
We have set up a web site and use ASP (not .NET) pages, utilizing the ADO object, to connect to the server with almost no problems.
We can use the same page repeatedly to connect, read and update the database, but randomly, we receive this error:
ASP 115 A trappable error (C0000005) occurred in an external object. The script cannot continue running.
We are now working with Microsoft to help us resolve this issue, however, they referred us to this KB article, which sounds like what's happening to us, except there are no *.RGS files found. The .DLL's found in the Oracle_Home\BIN folder are 10.2.0.1.
253449 Oracle Query or Stored Procedure from ASP and ADO Causes IIS to Stop Responding
http://support.microsoft.com/default.aspx?scid=kb;EN-US;253449
We have searched the web, including this forum, and tried everything we found. Obviously we're missing something. We're leaning toward believing there is a problem with this version of Oracle XE and Windows.
I'd like to know if there is anyone who is using Windows Server 2003, SP2 and XE (10.2.0.1) and connecting to XE through ASP using an ADO object? We are using the OraOLEdb10 driver with a TNSless connection string.
If so, I'd like to get some information on your setup to see where we may be different.
Any/All help is greatly appreciated.
Thank you,
Sandy G
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
4 Comments
Active 2 days ago
Nobody answers you.
possibly you have to address your question to the ASP thread.
So I will try to say some words.
See this
http://classicasp.aspfaq.com/general/how-do-i-solve-event-id-5-errors.html
It is an old error or an generic error.
I think you have to move to the latest version and to apply the latest patches.
possibly you have to address your question to the ASP thread.
So I will try to say some words.
See this
http://classicasp.aspfaq.com/general/how-do-i-solve-event-id-5-errors.html
It is an old error or an generic error.
I think you have to move to the latest version and to apply the latest patches.
Thanks for the link. I will look at it further to see if there's something I missed.
I actually have more info. We eliminated the IIS Process by running the script through VBS and were able to generate the following errors in the application log.
Faulting application cscript.exe, version 5.6.0.8832, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x0002a756.
Faulting application cscript.exe, version 5.6.0.8832, faulting module OraOLEDBrst10.dll, version 10.2.0.1, fault address 0x0000e337.
Faulting application cscript.exe, version 5.6.0.8832, faulting module msvcrt.dll, version 7.0.3790.3959, fault address 0x00038efa.
I'm working with MS on this issue and will update this thread as soon as I get more info from them.
If the OraOLEDBrst10.dll is the culprint, I'm not sure how to get a newer version since this is what came with Oracle Express 10g. Should I try to get the driver to Oracle 11?
FYI - MDAC is up to date since we have the latest service pack on the server.
I actually have more info. We eliminated the IIS Process by running the script through VBS and were able to generate the following errors in the application log.
Faulting application cscript.exe, version 5.6.0.8832, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x0002a756.
Faulting application cscript.exe, version 5.6.0.8832, faulting module OraOLEDBrst10.dll, version 10.2.0.1, fault address 0x0000e337.
Faulting application cscript.exe, version 5.6.0.8832, faulting module msvcrt.dll, version 7.0.3790.3959, fault address 0x00038efa.
I'm working with MS on this issue and will update this thread as soon as I get more info from them.
If the OraOLEDBrst10.dll is the culprint, I'm not sure how to get a newer version since this is what came with Oracle Express 10g. Should I try to get the driver to Oracle 11?
FYI - MDAC is up to date since we have the latest service pack on the server.
AFter producing a Heap dump for Microsoft, they replied that the heap was corrupted by DLLs from Oracle. OraOLEDBrst10.dll was trying to access memory that had previously been freed.
I will search for OraOLEDB dll patches. If none found, perhaps download the 11G drivers.
What is the next action for this question in Experts-Exchange?
I will search for OraOLEDB dll patches. If none found, perhaps download the 11G drivers.
What is the next action for this question in Experts-Exchange?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| IIS 8.0 and Kemp Load Master | 1 | 32 | |
| Select the 2 most recent visit dates | 5 | 29 | |
| Need to find a web event on the IIS server | 4 | 52 | |
| JQuery Data Table Default Sort | 2 | 31 |
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either.
In this article, I will show you how to enable the custom 40…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses
Course of the Month7 days, 9 hours left to enroll
739 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.