Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-08 : 08:01:47
|
| Will writes "I run a certain query in query analyzer and get results. When I attempt it using a vbscript, it timesout. I tried placing (Server.ScriptTimeout=#) in the page load block, but it doesn't seem to help. My SQL could probably stand tuning, but meanwhile, how can I stop my page from timing out?I'm reading counties for a given year, then determining which counties show up for the first time in a given week. I'm counting our members in each county and placing a checkmark next to a county that is new as of the given week.Using ASP.NETvbscriptMS SQL Server 2000WinXP sp2Thanks!" |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-02-08 : 15:55:06
|
| How are you connecting to the database? Is there a Connection object that you can set the Timeout value on. If so, this might default in your application and would need to be explicitly set to allow more time for the SQL to complete.HTH=================================================================Egotism is the anesthetic that dulls the pain of stupidity. -Frank William Leahy, football coach (1908-1973) |
 |
|
|
|
|
|
Timeout