How to maintain session state using SQL Server for classic ASP

Has anyone tried to maintain session state using SQL Server for classic ASP.

Any ideas or suggestions?

Thanks

 

It's a nightmare, but yes, I did that sort of thing for Siemens.

No trick to it really, but it does require you to maintain more than one session method.
i.e., Using server memory for SQL ID's/values while dropping some values in a cookie and or ugh, URL.

The problem isn't Microsoft's fault, it's our glorious STATELESS Internet protocol.

You no doubt already know this but...
ASP doesn't do a round trip for you, but ASP.NET (Compiled pages) do.
So the solution may be there, however everyone realizes how difficult it can be to migrate.
Salute,
Mark

 

i think it can be done by using the database for the session store on both sides (.net and classic) and installing a COM object.

http://msdn.microsoft.com/en-us/library/ms972429.aspx

i would LOVE it if you guys would install the dll that comes with the package in the above url.