Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to know if Connection is working ?
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement