Global.asa problem--->ASP error 0115

[dan....@mail.snet.net]

After I executed an ASP page last night, I noticed that any page with the
.asp extension results in the following error:
________________
error 'ASP 0115'
Unexpected error
/member_login.asp
A trappable error occurred in an external object. The script cannot continue
running.
________________

Even if the ASP page doesn't have any ASP in it, it will still generate the
error.

Here's where it gets strange: My global.asa file was generated by MS Visual
Interdev, and it is nothing more than basic. If I clear out the contents of
my global.asa file, everything works great...no more errors. So I tried
taking each line out of global.asa....line by line...it seems that if the
global.asa file contains any reference to "Sub Session_OnStart"" or "Sub
Application_Onstart" then the error is generated. Otherwise, if the
globabl.asa is empty, everything works fine.

I am confident that my global.asa is correct...and so there is no question,
here it is:
________________
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Session_OnStart
'==Visual InterDev Generated - DataConnection startspan==
'--Project Data Connection
Session("DataConn_ConnectionString") =
"DSN=myconnection;DBQ=d:\server\database\mydatabase.mdb;DriverId=25;FIL=MS
Access;MaxBufferSize=512;PageTimeout=5;"
Session("DataConn_ConnectionTimeout") = 15
Session("DataConn_CommandTimeout") = 30
Session("DataConn_RuntimeUserName") = ""
Session("DataConn_RuntimePassword") = ""
'==Visual InterDev Generated - DataConnection endspan==
End Sub
</SCRIPT>
________________

I have searched the newsgroups inside and out, and I couldn't find any
instances of the same problem with global.asa.

**ANY suggestions will be much appreciated! Thank you in advance!**

Sincerely,

Dan Caron
dan....@mail.snet.net

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading

[Glenn Cazenave]

Hi Dan,

We are experiencing the exact same problem. We use many virtual roots on
the same server. When that error is present, it will continue unless we
disable the virtual root (global.asa). This is obviously unacceptable since
it only allows us to use machine DSNs. I want a fix for this.

Caz

dan....@mail.snet.net wrote in message
<6hnknu$69p$1...@nnrp1.dejanews.com>...

[Andy Davies]

Hi I am having the same problem. I am using IIS3 and I believe the problem
is related to some event log entries that look something like this

-----------------------------------------
The HTTP server was unable to load the ISAPI Application
'e:\InetPub\wwwroot\_vti_bin\shtml.dll'. The data is the error.
----------------------------------------

is anybody else seeing this

Andy
ada...@brann-interactive.com

[Ricardo Rabago]

Hello:

This seems to be a pattern I also have been fighting this over the last
three days. I have discovered that applying the right permissions under NT
4.0/SP3/IIS 4.0 maybe my answer/solution according to what I have been
reading about ADO and permissions . My ASP application works fine under my
dev. system (WinNT/FAT) and at my local ISP on IIS 3.0

http://x2.dejanews.com/=hotbot/getdoc.xp?AN=333678803&CONTEXT=893262587.1709
18308&hitnum=9

Still searching for a fix!
Ricardo

[Juan T. Llibre]

Questions :

Is ORDER_KEY a date field ?
Is GRAND_TOTAL a text field ?
Is ID a number field ?
Is CUSTOMER_ID a number field ?

In general, when retrieving session variables, remember that
anything set to a session variable, will be turned into a string...

Also, try simplifying this SQL :

SQLStmt = "SELECT CUSTOMER_ID AS ORDER_ID"
SQLStmt = SQLStmt & " FROM customer"
SQLStmt = SQLStmt & " WHERE ((ID = " & Session.SessionID & ")"
SQLStmt = SQLStmt & " AND (ORDER_KEY = #" & KEY & "#)) "
Set RS = Connection.Execute(SQLStmt)
ORDER_ID = RS("ORDER_ID")
Session("ORDER_ID") = ORDER_ID

To :

SQLStmt = "SELECT CUSTOMER_ID AS ORDER_ID"
SQLStmt = SQLStmt & " FROM customer"
SQLStmt = SQLStmt & " WHERE ((ID = " & Session.SessionID & ")"
SQLStmt = SQLStmt & " AND (ORDER_KEY = #" & KEY & "#)) "
Set RS = Connection.Execute(SQLStmt)
Session("ORDER_ID") = RS("ORDER_ID")

I'd also move the "cleanup" code to Session_OnEnd.
That's a more logical place for cleanup code.

I see a lot of commented-out response.writes.
You can't response.write in global.asa.
Make sure no response.writes remain in global.asa...

I see a lot of : Set RSxxx = Connection.Execute(SQLStmt),
but I don't see you opening, or closing, any recordset objects.

Maybe using the more traditional syntax : creating an ADODB.Recordset
for each RS...and closing the RS when finished with the data, would help.

The full syntax for that has changed with ADO 1.5 :
recordset.Open Source, ActiveConnection, CursorType, LockType, Options

The Options are usually left out, unless you have very complex needs,
so that makes the basic syntax :

recordset.Open Source, ActiveConnection, CursorType, LockType

Using ADO 1.0 syntax with ADO 1.5 will generate errors and
since you don't have anywhere for the errors to be reported to,
{ no HTML is written in global.asa ) you'd just get the 0115 error.

Make sure you declare the ActiveConnection, CursorType and LockType.
Look in the ADO 1.5 documentation for complete examples.

One more thing :

There's nothing in your code which absolutely needs to be in global.asa.
For debugging purposes, and even as a permanent solution, try doing it
from a test.asp.

You'll then get the ADO errors reported in html
...and your debugging job will be that much easier.

regards,

Juan T. Llibre
Microsoft Internet Development MVP, ClubIE Team 3
mailto:j.ll...@codetel.net.do
http://www.activeserverpages.com/multilingual
A Demo For Multilingual HTML Content from Databases
============================================
Ricardo Rabago wrote in message ...

>This seems to be a pattern I also have been fighting this over the last
>three days. I have discovered that applying the right permissions under NT
>4.0/SP3/IIS 4.0 maybe my answer/solution according to what I have been
>reading about ADO and permissions . My ASP application works fine under my
>dev. system (WinNT/FAT) and at my local ISP on IIS 3.0

[dan....@mail.snet.net]

I am using NT4.0 with IIS4.0 and Service Pack 3. I am aware of similar
problems with IIS3.0, and they are documented @ http://support.microsoft.com,
but this is a first with NT4.0. With 3.0, a hotfix is available that updates
the asp.dll file as well as a couple other files.

But, no documentation on this problem with IIS4.0! Help Me!!

Dan Caron

In article <6hnknu$69p$1...@nnrp1.dejanews.com>#1/1,

[Glenn Cazenave]

Not sure if this has any bearing, but I've installed MDAC 2.0 on our web
server and have not had a problem reported since 24 April.

I tried installing the ASP hotfix and ASP broke. I've reverted back.

Caz