You can test it by executing simple statment like "select 1".
The idea is from EPS software corporation whitepaper "Migrating you VFP application to client/server platform" written by Daniel LeClear . You can find it on http://www.eps-cs.com/white_papers.aspx.
Some other whitepapers are also very good IMHO. My favourite is "Comparing OOP in VFP with OOP in NET" written by Claudio Lassala and Markus Egger.
Many thanks to EPS SC.


>connection is made at start of application. But status of connection needs to be tested before each sqlexec(). App could be running for along time and lose connection. Then SQLexec() could fail. The idea is to test the connection before issuing SQLexex()
>
>Thank You Miles