psqlODBC 09.05.0300 (x86) - problem with SQL_QUERY_TIMEOUT

From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: psqlODBC 09.05.0300 (x86) - problem with SQL_QUERY_TIMEOUT
Date: 2016-07-04 13:31:07
Message-ID: trinity-ddfc91fd-a511-4e68-b183-78324c7548f8-1467639067064@3capp-gmx-bs49
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Andrus 2016-07-04 19:42:32 How to get correct error message before logging to database
Previous Message Huong Dangminh 2016-07-03 23:06:19 Re: Default for "Level of rollback on errors"