Page 1 of 1

ZEOS AND MSSQL TIME OUT

Posted: 05.08.2010, 15:47
by bernhard
we use delphi 7 and ZEOS 6.6 stable :

our SQL Query or a Stored procedure take more than 30 sec calc time on the MSSQL server. ZEOS always reports a time out after 30 sec. How to overwrite that value..... we would like 10 min. waiting time.

set the time out value on the server side to 0 does not help in our case :(

Posted: 30.08.2010, 00:24
by mdaems
Did you already try setting timeout=x into the connection parameters?
(Have a look at TZDBLibConnection.InternalLogin)

Mark

Posted: 05.10.2010, 12:23
by cytrinox
I've the same problem.

timeout=x only sets the login timeout, but not query timeout.

Posted: 13.10.2010, 23:43
by mdaems
Does a query timeout setting exist on the client (=libpq) level? If so, I see no reason why you can't write a patch!

Mark