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
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_SetConnectOptionOn 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 15AFAIK there is no url setting to configure it in the connection stringEl 16/10/2024 a las 21:42, Dave Cramer escribió:Looks like in PGAPI_SetConnectOptionOn 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