|
 |
asp_databases thread: error '800a01a8' in a database session
Message #1 by "llyal 2000" <lgordon.listserv@o...> on Tue, 20 Feb 2001 22:07:57
|
|
error '800a01a8' in a database session
I am trying to set up a copy of a website on an IIS at home. I can see
static webpages fine, but data access pages I have problems;
Here's my error when accessing page:
Microsoft VBScript runtime error '800a01a8'
Object required: 'Session(...)'
/Directory/profile.asp, line 164
Here's the offending code:
Set LetterRS = Session("DB").Execute( strSQL )
Here is the globa.asa routine called by offending code:
Sub Session_OnStart
Set Session("DB") = Server.CreateObject("ADODB.Connection")
Session("DB").Open("OSC")
End Sub
I can successfully connect to the database use in the problem code using:
Dim dbOSC
Dim rsDirectory
Set dbOSC = Server.CreateObject("ADODB.Connection")
dbOSC.Open "OSC"
Set rsDirectory = dbOSC.Execute("SELECT * FROM tblDirectory")
What do I need to do to have success?
Thank you!
--llyal
Message #2 by "Owen Mortensen" <ojm@a...> on Wed, 21 Feb 2001 08:42:13 -0700
|
|
You might check to make sure your application has been created properly in
IIS. (Put some debug code into global.asa to see if it's even being run).
The error '800a01a8' means that 'session' is not an object, i.e., it has not
been created.
Owen
-----Original Message-----
From: llyal 2000 [mailto:lgordon.listserv@o...]
Sent: Tuesday, February 20, 2001 10:08 PM
To: ASP Databases
Subject: [asp_databases] error '800a01a8' in a database session
error '800a01a8' in a database session
I am trying to set up a copy of a website on an IIS at home. I can see
static webpages fine, but data access pages I have problems;
Here's my error when accessing page:
Microsoft VBScript runtime error '800a01a8'
Object required: 'Session(...)'
/Directory/profile.asp, line 164
Here's the offending code:
Set LetterRS = Session("DB").Execute( strSQL )
Here is the globa.asa routine called by offending code:
Sub Session_OnStart
Set Session("DB") = Server.CreateObject("ADODB.Connection")
Session("DB").Open("OSC")
End Sub
I can successfully connect to the database use in the problem code using:
Dim dbOSC
Dim rsDirectory
Set dbOSC = Server.CreateObject("ADODB.Connection")
dbOSC.Open "OSC"
Set rsDirectory = dbOSC.Execute("SELECT * FROM tblDirectory")
What do I need to do to have success?
Thank you!
--llyal
Message #3 by "llyal 2000" <lgordon.listserv@o...> on Wed, 21 Feb 2001 16:26:08
|
|
Owen,
Good suggestion; I will put some debug code in tonight and see what I come
up with;
--llyal
> You might check to make sure your application has been created properly
in
> IIS. (Put some debug code into global.asa to see if it's even being
run).
> The error '800a01a8' means that 'session' is not an object, i.e., it has
not
> been created.
>
> Owen
>
> -----Original Message-----
> From: llyal 2000 [mailto:lgordon.listserv@o...]
> Sent: Tuesday, February 20, 2001 10:08 PM
> To: ASP Databases
> Subject: [asp_databases] error '800a01a8' in a database session
>
>
> error '800a01a8' in a database session
>
> I am trying to set up a copy of a website on an IIS at home. I can see
> static webpages fine, but data access pages I have problems;
>
>
> Here's my error when accessing page:
>
> Microsoft VBScript runtime error '800a01a8'
> Object required: 'Session(...)'
>
> /Directory/profile.asp, line 164
>
>
> Here's the offending code:
>
> Set LetterRS = Session("DB").Execute( strSQL )
>
>
> Here is the globa.asa routine called by offending code:
>
> Sub Session_OnStart
> Set Session("DB") = Server.CreateObject("ADODB.Connection")
> Session("DB").Open("OSC")
> End Sub
>
>
>
> I can successfully connect to the database use in the problem code using:
>
> Dim dbOSC
> Dim rsDirectory
>
> Set dbOSC = Server.CreateObject("ADODB.Connection")
> dbOSC.Open "OSC"
> Set rsDirectory = dbOSC.Execute("SELECT * FROM tblDirectory")
>
>
> What do I need to do to have success?
>
> Thank you!
>
> --llyal
|
|
|
View Cart
