>>When connecting to SQL server from a VFP 9 application where is the time out set? in VFP application or in SQL server?
>> How do I determine and change it? (I want to force a time out so that I can test my code).
>>
>>TIA
>
>Could someone explain what should happen to the SQL Connection handle variable when the Idle Times fires? For example, if I have the the following code:
>
>SQLSETPROP( nSqlConnHandle,"IdleTimeout", 1)
>
>
>What would happen to nSqlConnHandle if the application is idle for 1+ minutes?
>Or what would be returned by the following SQL:
>
>SQLEXEC( nSqlConnHandle, "SELECT CAST(1 as bit) As Test", "crsTestConnection")
>
>?
According to VFP documentation, the connection is closed at least 1 minute after it becomes idle (and up to 2 minutes). It is automatically reconnected when an ODBC operation requires it.
Keep in mind that the VFP connection handle is not the same as the ODBC connection handle. A reconnected timed out connection changes its ODBC connection handle (most probably) but not its VFP connection handle (the one that is really important for you).
----------------------------------
António Tavares Lopes