ASP.NET RSS ASP.NET RSS

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.

ASP.NET Syntax (Toggle Plain Text) 
  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

Quick Reply to Thread
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



.net 2.0 activexcontrol advice ajax alltypeofvideos application asp asp.net bc30451 bottomasp.net browser button c# c#gridviewcolumn checkbox click commonfunctions compatible confirmationcodegeneration content courier css dataaccesslayer database datagridview datagridviewcheckbox datalist deadlock development dgv dropdownlist dynamically edit expose feedback fill flash form formatdecimal forms formview gridview homeedition hosting iframe iis javascript jquery listbox login microsoft mono mouse mssql multistepregistration news numerical objects opera panelmasterpagebuttoncontrols parent radio ratings registration reportemail rotatepage save schoolproject search security serializesmo.table silverlight smartcard smoobjects software sql-server sqlserver2005 suse textbox tracking typeof unauthorized validation vb.net video videos virtualdirectory vista visual-studio visualstudio web webapplications webarchitecture webdevelopemnt webprogramming webservice xml xsl youareanotmemberofthedebuggerusers
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC