I have a page that uses Session variables when generating the SQL statements 
used to submit and retrieve data from a database. However, because I don't 
know how long the user will be on the page, setting the Session.Timeout 
property doesn't help me avoid errors (I can obviously set the value to a 
very high value, but that still doesn't completely solve the problem). Is 
there any way for me to avoid the Session timing out? Thanks.
-- 
Nathan Sokalski
njsokalski@hotmail.com
http://www.nathansokalski.com/

switch to the sql state server. you can then bump the session to days or 
weeks.

-- bruce (sqlwork.com)

Nathan Sokalski wrote:

> I have a page that uses Session variables when generating the SQL statements 
> used to submit and retrieve data from a database. However, because I don't 
> know how long the user will be on the page, setting the Session.Timeout 
> property doesn't help me avoid errors (I can obviously set the value to a 
> very high value, but that still doesn't completely solve the problem). Is 
> there any way for me to avoid the Session timing out? Thanks.

How exactly does the sql state server work? I am using SQL Server in this 
case, but I have a couple questions:

1. What is the syntax for sql state server? Could you give me an example or 
direct me to a page that does?

2. What if I am not using SQL Server, or what if a database is not involved 
at all?

3. Even though it is not a likely scenario in the case of the site I am 
working on, some people leave their browsers open for VERY long times, for 
example, if a site is informational, they might keep it minimized for a long 
time and occasionally look at it as a reference.

Thanks.
-- 
Nathan Sokalski
njsokalski@hotmail.com
http://www.nathansokalski.com/

"bruce barker"  wrote in message 
news:%23r25Sc80HHA.3940@TK2MSFTNGP05.phx.gbl...

> switch to the sql state server. you can then bump the session to days or 
> weeks.
>
> -- bruce (sqlwork.com)
>
> Nathan Sokalski wrote:
>> I have a page that uses Session variables when generating the SQL 
>> statements used to submit and retrieve data from a database. However, 
>> because I don't know how long the user will be on the page, setting the 
>> Session.Timeout property doesn't help me avoid errors (I can obviously 
>> set the value to a very high value, but that still doesn't completely 
>> solve the problem). Is there any way for me to avoid the Session timing 
>> out? Thanks. 

re:
!> How exactly does the sql state server work?

It stores session state in a SQL Server database.

re:
!> Could you give me an example or direct me to a page that does?

http://msdn2.microsoft.com/en-us/library/ms178586.aspx




Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
======================================
"Nathan Sokalski"  wrote in message news:eaOGrK90HHA.4236@TK2MSFTNGP06.phx.gbl...

> How exactly does the sql state server work? I am using SQL Server in this case, but I have a couple questions:
>
> 1. What is the syntax for sql state server? Could you give me an example or direct me to a page that does?
>
> 2. What if I am not using SQL Server, or what if a database is not involved at all?
>
> 3. Even though it is not a likely scenario in the case of the site I am working on, some people leave their browsers 
> open for VERY long times, for example, if a site is informational, they might keep it minimized for a long time and 
> occasionally look at it as a reference.
>
> Thanks.
> -- 
> Nathan Sokalski
> njsokalski@hotmail.com
> http://www.nathansokalski.com/
>
> "bruce barker"  wrote in message news:%23r25Sc80HHA.3940@TK2MSFTNGP05.phx.gbl...
>> switch to the sql state server. you can then bump the session to days or weeks.
>>
>> -- bruce (sqlwork.com)
>>
>> Nathan Sokalski wrote:
>>> I have a page that uses Session variables when generating the SQL statements used to submit and retrieve data from a 
>>> database. However, because I don't know how long the user will be on the page, setting the Session.Timeout property 
>>> doesn't help me avoid errors (I can obviously set the value to a very high value, but that still doesn't completely 
>>> solve the problem). Is there any way for me to avoid the Session timing out? Thanks.
>
>