Re: does CommandTimeout takes effect?
From: Arnie Mauer (xxx_at_nowhere.net)
Date: 01/06/04
- Next message: Hans van Leth: "Re: Row cannot be located for updating"
- Previous message: hami: "Selecting Databases"
- In reply to: Xie Bingpeng: "does CommandTimeout takes effect?"
- Next in thread: Brian Bushay TeamB: "Re: does CommandTimeout takes effect?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 6 Jan 2004 09:23:12 -0500
"Xie Bingpeng" <xbp@teabird.com.cn> wrote in message
news:3ffa8c10$3@newsgroups.borland.com...
> 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
- Next message: Hans van Leth: "Re: Row cannot be located for updating"
- Previous message: hami: "Selecting Databases"
- In reply to: Xie Bingpeng: "does CommandTimeout takes effect?"
- Next in thread: Brian Bushay TeamB: "Re: does CommandTimeout takes effect?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
