A
Alan Z. Scharf
1. I have a set of six async calls to SQLServer2000 SP's.
2. These six SP's run fine in SQLServer Query Analyzer when called from a
master SP executing the individual SP's in succession.
3. However, when executing these SP's in async fashion from a web form, the
process times out after about 60-65 seconds. The length of the entire
process will vary according to a date range set by choosing a date from a
dropdown. But it always stops processing at a date range which takes over
65 seconds. There are no error messages coming up.
4. I tried setting the Server.ScriptTimeout setting to 600 in the button
that starts the entire process, but that's probably not the right thing to
be setting.
5. What other timeout settings would be relevant?
Thanks very much.
Alan
2. These six SP's run fine in SQLServer Query Analyzer when called from a
master SP executing the individual SP's in succession.
3. However, when executing these SP's in async fashion from a web form, the
process times out after about 60-65 seconds. The length of the entire
process will vary according to a date range set by choosing a date from a
dropdown. But it always stops processing at a date range which takes over
65 seconds. There are no error messages coming up.
4. I tried setting the Server.ScriptTimeout setting to 600 in the button
that starts the entire process, but that's probably not the right thing to
be setting.
5. What other timeout settings would be relevant?
Thanks very much.
Alan