Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

ASP+, SQL, and Config.web?

Does anyone have and example of how to set up
the SQL Session Service, the config.web file, and
ASP+ in order to let SQL handle the sessions?

I set up a Win2000 server, installed the pre-beta
software, and IE5.5. I cannot find the SQL session
service anywhere...should it be there?

I searched through the news groups, and the web,
but i have yet to find a good resource for this topic.

Any help is greatly appreciated!! Thanks in advance!

Mike Gibson
mgibson@usbid.com
[530 byte] By [Michael Gibson] at [2007-11-9 16:23:53]
# 1 Re: ASP+, SQL, and Config.web?
I've seen this post elsewhere (haven't trid it yet, tho)

look for a file called "state.sql". Use osql to run it on the server you're
interested in:

osql -S <server> -U sa -P "" <state.sql

Then restart the SQL service so that the startup stored procedure that
deletes expired sessions can run.

In session state config, set "usesqlserver=true" and "server=<server>".

Hope this helps.

MCA

Michael Gibson <mgibson1@cfl.rr.com> wrote in message
news:39a3c5ee@news.dev-archive.com...
> Does anyone have and example of how to set up
> the SQL Session Service, the config.web file, and
> ASP+ in order to let SQL handle the sessions?
>
> I set up a Win2000 server, installed the pre-beta
> software, and IE5.5. I cannot find the SQL session
> service anywhere...should it be there?
>
> I searched through the news groups, and the web,
> but i have yet to find a good resource for this topic.
>
> Any help is greatly appreciated!! Thanks in advance!
>
> Mike Gibson
> mgibson@usbid.com
>
>
Mike Amundsen at 2007-11-11 23:26:23 >
# 2 Re: ASP+, SQL, and Config.web?
Thanks for the help!

I do have another question though....I can't seem to find
the "state.sql" file anywhere on my box.

Where can I find it, or can anyone send it to me?

Thanks in advance for the help!

Mike Gibson
mgibson@usbid.com

"Mike Amundsen" <news@amundsen.com> wrote in message
news:39a46d6f$1@news.dev-archive.com...
> I've seen this post elsewhere (haven't trid it yet, tho)
>
>
> look for a file called "state.sql". Use osql to run it on the server
you're
> interested in:
>
> osql -S <server> -U sa -P "" <state.sql
>
> Then restart the SQL service so that the startup stored procedure that
> deletes expired sessions can run.
>
> In session state config, set "usesqlserver=true" and "server=<server>".
>
> Hope this helps.
>
> MCA
>
> Michael Gibson <mgibson1@cfl.rr.com> wrote in message
> news:39a3c5ee@news.dev-archive.com...
> > Does anyone have and example of how to set up
> > the SQL Session Service, the config.web file, and
> > ASP+ in order to let SQL handle the sessions?
> >
> > I set up a Win2000 server, installed the pre-beta
> > software, and IE5.5. I cannot find the SQL session
> > service anywhere...should it be there?
> >
> > I searched through the news groups, and the web,
> > but i have yet to find a good resource for this topic.
> >
> > Any help is greatly appreciated!! Thanks in advance!
> >
> > Mike Gibson
> > mgibson@usbid.com
> >
> >
>
>
Michael Gibson at 2007-11-11 23:27:17 >