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-02-20 : 09:15:10
|
| sheing writes "Dear SQLTeam,I cannot execute the SQL Statement in application or stored procedure, the error message is:[Microsoft] [ODBC SQL Server] Timeout Expiredbut when i run it in Query Analyzer it works fine.What should I do?Thank you,SheIng" |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-02-20 : 09:46:01
|
| What is the query you are using? Is it slow in Query Analyzer? Have you examined the execution plan of the query?Edited by - andre on 02/20/2002 09:46:33 |
 |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-02-20 : 13:29:48
|
| If you are using ado, there is a command timeout property in the connection object.*************************Just trying to get things done |
|
|
|
vladimir_grigoro
Yak Posting Veteran
62 Posts |
Posted - 2002-02-24 : 03:54:22
|
| If you are using ADO the timeout property is set to 30sec. You can modify this property to set greater timeout. If you set the timeout property to 0 you will have no limit for execution of the query but it is not reccomended.But first check your execution plan in the Query Analyzer, each table should be indexed and should have updated statistic for better performance. |
|
|
|
|
|
|
Timeout Expired while execute SQL statement