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
I loaded the OraOle files from the Oracle ODAC for 11g and the problem has disappeared. So far, this appears to have resolved our problem.
Hopefully this post will provide some help for another user.