Devart Forums

I tried to apply a custom CommandTimeout to our Connection as described in the readme.htm file that comes with the drivers but it does not work.

Tried the following

CRSQLConnection.Params.Values['CommandTimeout'] := '3';

and also tried

CRSQLConnection.Params.Values['Command Timeout'] := '3';

both before opening the connection, but no effect. Opened a long running query which did not return before completion. Maybe 30-40 Seconds.

Delphi 6.02
Latest dbxsda drivers and sources
SQL Server 2008

Any help greatly appreciated.

Any feedback from Devart ?

To whom it may concern,

We are a paying customer of DevArt (formerly CoreLAb) since years and we are therefore expecting a certain level of support.

This is an urgent problem for us (as are the other two issues currenlty open see forum). We are using dbexpress drivers for real world applications not just for fun.

If DevArt is unable or unwilling to solve the problem, please drop a message saying that so we don't have to poll the forum every hour to see if you have kindly posted a solution or answer.

If there is another support channel that we should use, let us know.

Thanks
Martin

We could not reproduce this problem with simple WAITFOR command. Please specify your SQL statement.

SELECT * FROM Table

where Table is a large Table with 15 million rows. Open() does not come back for a very long time.

We have specified Params.Values('Command Timeout') := '3'; before opening the connection.

No abort after 3 seconds.

Tried with SqlOLEDb and native Client libraries.

no luck

When FetchAll is True the open operation consists of statement execution and data fetching. The CommandTimeout parameter affects statement execution and fethcing of data blocks separately. So it does not affect anything. Please consider using FetchAll = False mode.

Challenger wrote:When FetchAll is True the open operation consists of statement execution and data fetching. The CommandTimeout parameter affects statement execution and fethcing of data blocks separately. So it does not affect anything. Please consider using FetchAll = False mode.

Ok, I see.

Could you show me a snippet of code for Delphi6 that set's timeout=3 and fetchall=false just to make sure, I'm using the right way to set those two params ?

Thanks
Martin

martin wrote:Could you show me a snippet of code for Delphi6 that set's timeout=3 and fetchall=false just to make sure, I'm using the right way to set those two params ?

You can use the following code:

Thank you Dimon.