I have a problem with a sub web using ASP. I create a session var
for the connection object in my Global ASA file. I instantiate the
object, set the properties for the object and when a page tries to
use the object, I get an error -2146827864, Object Required. It is
as if the Session Variable for the connection object is not seen by
the ASP pages.
The reason this is driving me batty is that this code is identical to
the code on another Sub Web on the same site, using the same database
with the exception of one Application Variable which defines
the "root" web for the user.
The error occurs on Line 18, response.write "CS: " & Session
("Conn").ConnectionString & "<BR>", in test.asp.
Here is the Global ASA file and the asp code for the test page.
GLOBAL.ASA
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-
1252">
<title>New Page 1</title>
</head>
<body>
<%
response.write "TO: " & Session.Timeout & "<BR>"
response.write "LI: " & Session("LoggedIn") & "<BR>"
response.write "NA: " & Session("NumAttempts") & "<BR>"
response.write "UID: " & Session("UserID") & "<BR>"
response.write "UL: " & Session("UserLevel") & "<BR>"
response.write "SID: " & Session("SchoolID") & "<BR>"
response.write "CS: " & Session("Conn").ConnectionString
& "<BR>"
response.write "CTO: " & Session("Conn").ConnectionTimeOut
& "<BR>"
response.write "CT: " & Session("Conn").CommandTimeout
& "<BR>"
response.write "CL: " & Session("Conn").CursorLocation
& "<BR>"
response.write "STATE: " & Session("Conn").State
%>
</body>
</html>
test.asp
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-
1252">
<title>New Page 1</title>
</head>
<body>
<%
response.write "TO: " & Session.Timeout & "<BR>"
response.write "LI: " & Session("LoggedIn") & "<BR>"
response.write "NA: " & Session("NumAttempts") & "<BR>"
response.write "UID: " & Session("UserID") & "<BR>"
response.write "UL: " & Session("UserLevel") & "<BR>"
response.write "SID: " & Session("SchoolID") & "<BR>"
response.write "CS: " & Session("Conn").ConnectionString
& "<BR>"
response.write "CTO: " & Session("Conn").ConnectionTimeOut
& "<BR>"
response.write "CT: " & Session("Conn").CommandTimeout
& "<BR>"
response.write "CL: " & Session("Conn").CursorLocation
& "<BR>"
response.write "STATE: " & Session("Conn").State
%>
</body>
</html>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
