| 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
>
>
>
| 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 |