In adition, I will sugest you to set IdleTimeout property of connection to a value greater than 0.
After the time specified is elapsed, VFP will automatically close the connection and will try to reconnect when SQLEXEC() is executed (or TABLEUPDATE() with remote views). If will not succed and table buffering is used, you can still acces inserted/modified records with GETNEXTMOFIED(), save locally and try later the update.

Dorin

>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