Miles,

Use SQL connect and check its return value.

From VFP Help

SQLCONNECT( ) returns a positive non-zero numeric handle if you successfully connect to the data source. You should store this handle in a memory variable and use the variable in subsequent function calls that require a connection handle. SQLCONNECT( ) returns – 2 if the connection cannot be made.