Storing Session State

HI All

Looking for some advice on session in ASP.
We are running windows 2000 with dot.net framework 1.1 on IIS 5.1

This is an NLB architecture with the session being stored in an SQL DB.
We have been coding and deploying using ASP.NET with no problems
however the 'powers that be' have recently bought an online booking
application which has been coded using classic asp.

We have set the session location in the machin config of the framework
stating
mode="SQLServer". Will this ASP use this or continue to store the code
InProc?

Thanks

Michael D

Bob
Tue May 09 05:40:16 CDT 2006

michdoh@yahoo.com wrote:
> HI All
>
> Looking for some advice on session in ASP.
> We are running windows 2000 with dot.net framework 1.1 on IIS 5.1
>
> This is an NLB architecture with the session being stored in an SQL
> DB. We have been coding and deploying using ASP.NET with no problems
> however the 'powers that be' have recently bought an online booking
> application which has been coded using classic asp.
>
> We have set the session location in the machin config of the framework
> stating
> mode="SQLServer". Will this ASP use this

No. Classic ASP has no knowledge of this. You would have to write your own
code to store session state in a database

or continue to store the
> code InProc?
>
That's the only way that was available when classic ASP was developed.
See
http://msdn.microsoft.com/library/en-us/iissdk/html/fd6ec94e-2493-4edb-affc-b18391334081.asp

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Bob
Tue May 09 05:41:39 CDT 2006

michdoh@yahoo.com wrote:
> HI All
>
Oops, this is the link I meant to send you to (although the other one is
interesting as well):
http://msdn.microsoft.com/library/en-us/iissdk/html/2c40c3cf-90eb-41ca-ae2a-0ef33a651779.asp

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

michdoh
Tue May 09 06:22:28 CDT 2006

Thanks for this quick reply. You have saved me an emense amount of
effort

Egbert
Tue May 09 12:11:16 CDT 2006


<michdoh@yahoo.com> wrote in message
news:1147169987.430581.147170@i39g2000cwa.googlegroups.com...
> HI All
>
> Looking for some advice on session in ASP.
> We are running windows 2000 with dot.net framework 1.1 on IIS 5.1
>
> This is an NLB architecture with the session being stored in an SQL DB.
> We have been coding and deploying using ASP.NET with no problems
> however the 'powers that be' have recently bought an online booking
> application which has been coded using classic asp.

The product below has been a proven solution for web farms using classic
asp.

--
compatible web farm Session replacement for Asp and Asp.Net
http://www.nieropwebconsult.nl/asp_session_manager.htm