Re: Connection / Login Timeout

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ó:
>> 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
>>
>>
>>
--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.
Tel: (11) 3500-1410