Re: [ODBC] BUG: odbc statement_timeout gets set to 30000 - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: [ODBC] BUG: odbc statement_timeout gets set to 30000
Date
Msg-id 2ac1ec8f-6db8-aaea-6bed-f818651b64f6@dream.email.ne.jp
Whole thread Raw
In response to Re: [ODBC] BUG: odbc statement_timeout gets set to 30000  ("Arnaud L." <arnaud.listes@codata.eu>)
Responses Re: [ODBC] BUG: odbc statement_timeout gets set to 30000  ("Arnaud L." <arnaud.listes@codata.eu>)
List pgsql-odbc
Hi,

On 2017/11/17 16:39, Arnaud L. wrote:
> Le 17/11/2017 à 08:34, linuxyeti a écrit :
>> I've found a problem with at least the 906 and 1000 odbc driver, in 
>> that, no
>> matter what statement_timeout is set to, after initially connecting and
>> setting the value to that specified in the connection settings, it is 
>> then
>> subsequently set to 30000.
>
> I've witnessed it too, and fixed it by setting my ado connection's 
> commandtimeout to 0 in my scripts. (oADODBConn.CommandTimeout = 0)

The default value of CommandTimeout property is 30.

>
> But just like you I was surprised by this change, so it might be a bug.

It's because of an enhancement (SQL_QUERY_TIMEOUT option support since 
9.5.0400)  not a bug.

regards,
Hiroshi Inoue

>
>
> Regards
>
> -- 
> Arnaud
>
>



-- 
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

pgsql-odbc by date:

Previous
From: "Arnaud L."
Date:
Subject: Re: [ODBC] BUG: odbc statement_timeout gets set to 30000
Next
From: "Arnaud L."
Date:
Subject: Re: [ODBC] BUG: odbc statement_timeout gets set to 30000