ASP and SQL Session State

[RichW]

I know this is probably a really silly question, but can ASP
applications use SQL Session State (ie. the ASPState database that
..net applications can use)? If so, has anyone got any ASP code that
shows what is required. (I have been asked this question by someone
at work and haven't been able to find an answer).

Cheers,


Rich

 

[Kevin Spencer]

That is one of the reasons that ASP.Net was architected the way it is. While
you could probably use a database as a Session server with ASP, it would be
a rather daunting task. Still, if you're dead set on doing this with ASP,
you might try asking in the microsoft.public.inetserver.asp.general
newsgroup.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

 

[bruce barker]

in theory yes, in pratice maybe. in appstate the session data is stored in a
binary column. its just the serialization of the .net objects in your
session. for asp to access it, it would need to unserialize the data, or if
it wanted to add data, it need to serialize in a known .net objects format.
you could add a column to the table and store asp data there.

-- bruce (sqlwork.com)



| I know this is probably a really silly question, but can ASP
| applications use SQL Session State (ie. the ASPState database that
| .net applications can use)? If so, has anyone got any ASP code that
| shows what is required. (I have been asked this question by someone
| at work and haven't been able to find an answer).
|
| Cheers,
|
|
| Rich