Re: SQL_QUERY_TIMEOUT

Hi,

This is only way to use SQL_QUERY_TIMEOUT?
Can I setup this in odbc.ini like global parameter for all my
connections (applications)?
It can be useful to independently check/break (outside application -
when using third-party applications ) dead connection or unexpected long
running query or other communication error.

Other databases(ODBC clients) has parameter to set up this in config file.
For example DB2 ODBC client has parameter ReceiveTimeout where I can
setup how many second client wait for response from server. After this
timeout client return communication error. This is great parameter for
situation when I use third-party applications, for example.

Regards

Ondrej Dzivy Balucha
Horizon, s.r.o. Prešov
Francisciho 21
08001 Prešov
tel/fax +421517491400/02

On 06.05.2017 04:59, Inoue, Hiroshi wrote:
> Hi Ondrej,
>
> On 2017/05/05 22:09, Ondrej Dzivy Balucha wrote:
>> Hi,
>>
>> I found that in psqlODBC 09.05.0300 Release was implemented
>> SQL_QUERY_TIMEOUT.
>> How it works?
>
> Please call ODBC API like
>
> SQLSetStmtAttr(hstmt, SQL_ATTR_QUERY_TIMEOUT, (void *) timeout, 0);
>
> regards,
> Hiroshi Inoue
>
>> I need to set up odbc connection in Debian, that send me
>> error(disconnet dead connection) after defined time, but I can`t find
>> how can I setup SQL_QUERY_TIMEOUT in odbc.ini.
>> I have installed latest odbc driver(09.06.0200)
>>
>> Regards
>