SessionState SQL Server timeout doesn't work

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Aug 2007
Posts: 178
Reputation: Kusno is an unknown quantity at this point 
Solved Threads: 14
Kusno's Avatar
Kusno Kusno is offline Offline
Junior Poster

SessionState SQL Server timeout doesn't work

 
0
  #1
Jul 30th, 2009
Dear all,

I have a problem for my session state.
Previously, I used session state InProc, but because CPU usage was very high cause IIS sometimes restarts, so I changed it to SQLServer.

but now, session doesnt want to expire even I set timeout to 1 minute !!!.

this is my session state syntax.

  1. <sessionState mode="SQLServer" cookieless="false" regenerateExpiredSessionId="true" timeout="1" sqlConnectionString="Data Source=xxx.114.30.xx;UID=sa;pwd=****;Integrated Security=false;" sqlCommandTimeout="90"/>
Could you help me to solve my problem?

I use SQL Server 2005, Windows 2003 Server and IIS 6.

Thanks
NEVER NEVER NEVER GIVE UP
Reply With Quote Quick reply to this message  
Join Date: Sep 2008
Posts: 76
Reputation: kameswari is an unknown quantity at this point 
Solved Threads: 15
kameswari kameswari is offline Offline
Junior Poster in Training

Re: SessionState SQL Server timeout doesn't work

 
0
  #2
Jul 30th, 2009
i think you need to use Session.Abandon() method to kill the session...
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the ASP.NET Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC