I need to know if a connection from VFP to SQL server is working before calling SP.
Does someone knows how to do this ?
I'm creating a Connection using SqlStringConnect() to the server.

Would like to do something like Ping to the server to test the active connection.

I know that I could create another connection using SQL-DMO to test and then close this connection before calling Stored Procedures using the first connection of the app, but I would like to test the connection using only one connection.

Thanks in Advance.

Peter