Hi Peter,
For details check sqlconnect() help.
SQLSTRINGCONNECT( ) returns a positive nonzero numeric value as the statement handle if you successfully connect to the data source. SQLSTRINGCONNECT( ) returns –1 if it cannot make the connection.
>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