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

From Luiz Matsumura
Subject Re: Connection / Login Timeout
Date
Msg-id b1987154-1370-4a86-ba65-015c6f724c71@planit.com.br
Whole thread Raw
In response to Re: Connection / Login Timeout  (Jacobo Sánchez López <jsanchez@denodo.com>)
List pgsql-odbc

Hi,

Unfortunately I found that my programming language (Visual FoxPro, don't judge me) don't allow to set this before connection.
I found the function SqlSetProp() but this function need the handle of connection as parameter, that is just returned by SqlConnect() or SqlStringConnect(), therefore after having a successfull conection.
I wanted to put a value lesser than the default 15 seconds to detect an unsuccessfull connection.

Thanks for the help, but I think if it is not possible to configure it by the connection string it will not be possible in VFP.


Em 17/10/2024 05:19, Jacobo Sánchez López escreveu:

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



-- 
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.
Tel: (11) 3500-1410

pgsql-odbc by date:

Previous
From: Jacobo Sánchez López
Date:
Subject: Re: Connection / Login Timeout
Next
From: Administrativo
Date:
Subject: How to compile and how to test it in windows ?