>>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?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
