ZEOS AND MSSQL TIME OUT

[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

[mdaems]

Did you already try setting timeout=x into the connection parameters?
(Have a look at TZDBLibConnection.InternalLogin)

Mark

[cytrinox]

I've the same problem.

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

[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