Thread: Connection / Login Timeout

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

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

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

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.

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