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 - 2002-10-18 : 09:04:24
|
| Prakash writes "Sir, I got "DBMSSCON General Network Err" when i was running the query (abt 40000 records) using asp file. after 3 minutes passed i got this err.but i'm sure there was no err in asp file and Query also.evethough i set the delay propery in SQL Server as 0 and Settimeout property in asp abt 1 hr, i got this err.What problem acutaly ? and also i set the timeout property to 0 in the IIS Virtual Directory.Plz give me a remedy as soon as possible.Thanks in advance.Sincerely,Prakash" |
|
|
jflores
Starting Member
2 Posts |
Posted - 2002-10-18 : 09:56:15
|
| it's you connection string |
 |
|
|
jflores
Starting Member
2 Posts |
Posted - 2002-10-18 : 09:58:01
|
quote:
it's you connection stringyou need to add thisConn.CommandTimeout = 1000
|
|
|
|
|
|
|
Qry Timeout Err (When Testing with bulk records)