Re: Connection / Login Timeout - Mailing list pgsql-odbc

From Jacobo Sánchez López
Subject Re: Connection / Login Timeout
Date
Msg-id 6703f29a-1635-40bc-ab47-8d07e2979449@denodo.com
Whole thread Raw
In response to Re: Connection / Login Timeout  (Dave Cramer <davecramer@postgres.rocks>)
Responses Re: Connection / Login Timeout
List 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ó:

On Wed, 16 Oct 2024 at 11:59, Administrativo <adm@planit.com.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



pgsql-odbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Connection / Login Timeout
Next
From: Luiz Matsumura
Date:
Subject: Re: Connection / Login Timeout