I'd like to check from VFP application if SQL server is available for connection.

I can do it with

...
wait window "Please wait..."
SQLSETPROP(0,'DispLogin',3)
MyHandle=SQLStringConnect(MyConnString)
wait clear
...

and after that I can test what in MyHandle is.

The only problem is - if server is not available - it takes too long and I'd like to do this in background even without displaying the wait window. I don't know if it is possible to set some shorter duration of SqlStringConnect command or to test the availability of the server with some other way. I played with "Connection Timeout" settings in connection string, but it doesn't work with me.


Thank's, Zlatko.