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-01-18 : 10:42:56
|
| Jamie writes "I am using version 7.0 with service pack 2 installed. The problem I having is with a view that pulls some records together. I can create the view fine and if I select against it in query analyzer I receive results with no problem. I then step through my COM component and set a breakpoint right before the oRS.Execute(strSql) command. I'm using ADO by the way. I then copy the sql from the COM and paste it into Query Analyzer, again, it returns results without a problem. When I allow the oRS.Execute statement to run, after about 20 seconds, I receive a "timeout expired" message." |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-19 : 01:24:48
|
| Increase your Connection timeout setting and try Connection.CommandTimeout=60 orCommand.CommandTimeout=60----------------------------------"True love stories don't have endings." |
 |
|
|
|
|
|
Query runs fine in Query analyzer gives timeout error from COM