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