Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Timeout?
Message
From
14/12/2000 04:23:06
 
 
To
13/12/2000 14:30:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00453029
Message ID:
00453253
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform