Re: Connection / Login Timeout

From: Jacobo Sánchez López <jsanchez(at)denodo(dot)com>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: Connection / Login Timeout
Date: 2024-10-17 08:19:46
Message-ID: 6703f29a-1635-40bc-ab47-8d07e2979449@denodo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

That setting is on the ODBC API. You can set it using the
SQLSetConnectAttr  API method (See
https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlsetconnectattr-function)

As an example Power-BI does set it to 15 seconds by default, see the
following ODBC trace fragment:

ENTER SQLSetConnectAttrW
SQLHDBC 0x00000000060673E0
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 15

AFAIK there is no url setting to configure it in the connection string

El 16/10/2024 a las 21:42, Dave Cramer escribió:
> Looks like in PGAPI_SetConnectOption
>
> https://github.com/postgresql-interfaces/psqlodbc/blob/c362d981c05014fed245f8c77de5cc642bd7d750/options.c#L297C1-L297C23
> Dave Cramer
> www.postgres.rocks
>
>
> On Wed, 16 Oct 2024 at 11:59, Administrativo <adm(at)planit(dot)com(dot)br> wrote:
>
> Hi,
>
> In the release documentation, version 08.02.0006 added support for
> LOGIN_TIMEOUT , but how to configure this ?
>
> It's possible to configure  throught the connection string ?
>
> Thanks in advance.
>
>
> Luiz
>
>
>

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Luiz Matsumura 2024-10-17 11:54:43 Re: Connection / Login Timeout
Previous Message Dave Cramer 2024-10-16 19:42:17 Re: Connection / Login Timeout