| Author |
Topic |
|
juicyapple
Posting Yak Master
176 Posts |
 Posted - 2008-06-03 : 20:35:56
|
| Hi, my web application always encounter session timeout even I have set the session timeout to 120 minutes, and asp script timeout to 7200 seconds in application configuration in IIS. please advise. Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 21:32:56
|
| Happened when connect to db? |
 |
|
|
juicyapple
Posting Yak Master
176 Posts |
Posted - 2008-06-03 : 21:56:17
|
quote:
Originally posted by rmiao
Happened when connect to db?
yes. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 23:18:27
|
| You can test sql connection with odbc on web server. How does asp's connection string look like? Is sql running on another machine? |
|
|
|
juicyapple
Posting Yak Master
176 Posts |
Posted - 2008-06-04 : 04:32:12
|
quote:
Originally posted by rmiao
You can test sql connection with odbc on web server. How does asp's connection string look like? Is sql running on another machine?
not very understand what do you mean. THe connection string is Data Source=server1;Initial Catalog=db1;User ID=user1;Password=pwd1Why would the session time out be affected by the db connection? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-04 : 22:45:55
|
| App will timed out if can't connect to sql server within time out limit. |
|
|
|
juicyapple
Posting Yak Master
176 Posts |
Posted - 2008-06-09 : 01:24:47
|
quote:
Originally posted by rmiao
App will timed out if can't connect to sql server within time out limit.
Thanks for your info. My app is only connecting to sql server during retrieving data, it will close the connection once completed. It takes less than 1 minute. It shouldn't cause the problem right? please advise. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-09 : 22:04:10
|
| What's timeout setting? If it's 1 minute but sql server didn't response connection request in 1 minute, app will get connection timeout error. |
|
|
|
juicyapple
Posting Yak Master
176 Posts |
Posted - 2008-06-11 : 05:51:57
|
quote:
Originally posted by rmiao
What's timeout setting? If it's 1 minute but sql server didn't response connection request in 1 minute, app will get connection timeout error.
I am not sure, how to check this. Usually I open a page, with or without action on it, after 20 minutes it will time out. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-11 : 22:32:29
|
| Trace it in profiler to see if request ever goes to sql server. |
|
|
|
juicyapple
Posting Yak Master
176 Posts |
Posted - 2008-06-19 : 09:07:21
|
| the problem still not solve, one of the web application has timeout problem during first load up. Please help. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-19 : 22:39:22
|
| Did you trace it in profiler? |
|
|
|
juicyapple
Posting Yak Master
176 Posts |
Posted - 2008-06-20 : 05:56:10
|
quote:
Originally posted by rmiao
Did you trace it in profiler?
not yet. Never do before. |
|
|
|
|
Session timeout