Francisco:

THANKS!!! I'll set it as you instruct and see what happens.

Mal

>The querytimeout, is a SQLServer property that specifies the amount of time that ba query can run on the server.
>If you try to execute a query that takes longer than that, SQL Server returns this error.
>
>You specify it in seconds. And Zero means, never timeout (the error never shows even if the query takes two days to complete).
>
>You can specify it in the Server properties. But you can set it, in a per connection basis, from inside VFP by issuing:
>
>

=sqlsetprop(m.MyConnectionHandle,'QueryTimeOut', m.MyNumberofSeconds)

>
>
>
>>Hi:
>>
>>While my program is running, I receive an error message that says that my connection to SQL Server (7.0) TIMEDOUT ... expired.  Of course this crashes the program.
>>
>>Can anyone tell me what this is?  I don't recall setting a time limit anywhere.
>>
>>TIA
>>
>>Mal