Board index » delphi » does CommandTimeout takes effect?

does CommandTimeout takes effect?


2004-01-06 06:24:32 PM
delphi33
hi all:
I using Delphi 7, SQL Server 2000.
I convert my application from BDE to ADO, In BDE version,
I fetch and Update sql server datas all right, but in
ADO version, sime times "Time out" error occurs when operate
SQL server.
I think TADOConnetion and TADOQuery's CommandTimeout may controls
this, But I write a test program to test this, found CommandTimeout
takes no effect.
I also set SQL Server's Query time-out to 0 (unlimited), but no effect.
How to resolve "Time out" problem?
thanks.
 
 

Re:does CommandTimeout takes effect?

"Xie Bingpeng" <XXXX@XXXXX.COM>writes
Quote
hi all:
I using Delphi 7, SQL Server 2000.
I convert my application from BDE to ADO, In BDE version,
I fetch and Update sql server datas all right, but in
ADO version, sime times "Time out" error occurs when operate
SQL server.
I think TADOConnetion and TADOQuery's CommandTimeout may controls
this, But I write a test program to test this, found CommandTimeout
takes no effect.
I also set SQL Server's Query time-out to 0 (unlimited), but no effect.

How to resolve "Time out" problem?

thanks.
The TADOQuery CommandTimeout value will override that of the connection. We
had the problem, but setting the query's CommandTimeout value to zero solved
the problem.
- Arnie