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: 176
Reputation: Kusno is an unknown quantity at this point 
Solved Threads: 13
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: 74
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 3.5 ajax alltypeofvideos appliances asp asp.net beginner box browser businesslogiclayer button c# cac checkbox class commonfunctions compatible content contenttype control countryselector courier dataaccesslayer database datagrid datagridview datalist deployment development dgv dialog dropdownlist dropdownmenu dynamic dynamically edit embeddingactivexcontrol fileuploader fill findcontrol flash flv gridview gudi iis javascript list listbox login menu microsoft mouse mssql nameisnotdeclared news novell numerical opera order panelmasterpagebuttoncontrols problem radio ratings redirect registration relationaldatabases reportemail schoolproject search security serializesmo.table sessionvariables silverlight smoobjects software sql sql-server sqlserver2005 ssl tracking treeview validatedate validation vb.net videos vista visual-studio visualstudio vs2008 web webapplications webarchitecture webdevelopment webprogramming webservice wizard xsl youareanotmemberofthedebuggerusers
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC