Postgres Pro
Downloads
Home   >   mailing lists

psqlODBC 09.05.0300 (x86) - problem with SQL_QUERY_TIMEOUT - Mailing list pgsql-odbc

From Jan-Peter Seifert
Subject psqlODBC 09.05.0300 (x86) - problem with SQL_QUERY_TIMEOUT
Date
Msg-id trinity-ddfc91fd-a511-4e68-b183-78324c7548f8-1467639067064@3capp-gmx-bs49
Whole thread Raw
Responses Re: psqlODBC 09.05.0300 (x86) - problem with SQL_QUERY_TIMEOUT  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
List pgsql-odbc
Tree view 
Hello,

it looks like SQL_QUERY_TIMEOUT is on by default - causing dead connections with long running statements:

"SQLSTATE = 00000 Native Error = 26 Could not send Query(connection dead)"

I tested with 9.3.400 (without problems) as well.

How can I disable it? Adding "statement_timeout = 0" to the "Connect Settings" field on Advance Options Page 2?

Could you tell me, please?

Thank you very much!

Best regards,

Peter

pgsql-odbc by date:

Previous
From: Huong Dangminh
Date:
Subject: Re: Default for "Level of rollback on errors"
Next
From: "Andrus"
Date:
Subject: How to get correct error message before logging to database