>>>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
>>
>>sqlsetprop(0, 'ConnectTimeOut', lnTimeOutInSeconds)
>>
>>
>>To test you can misspell the name of the server.
>
>Hugo,
>
>I probably misunderstood. Say my app creates a connection to the SQL Server and the handle number is 1. So I want to make this hand to time out in 10 seconds. I tried:
>

>sqlsetprop(1, 'ConnectTimeOut', 10)
>

>
>Then I wait 10+seconds but the connection handle (1) is still valid. What am I missing?

Ah, I missunderstood, I thought you wanted to time out when unable to connect for n seconds, what you want is IdleTimeout. "The idle timeout interval in minutes. Active connections are deactivated after the specified time interval. The default value is 0 (wait indefinitely). Read/write."

SQLSETPROP(1,"IdleTimeout", 1)

Hugo