Post reply

SQL Server Connection Test

  • May 27, 2003 at 8:32 am

    #159975

    How do you test ('ping') the SQL Server without executing any queries? How is the 'Test Connection' utility performed?

    Andy39

  • May 27, 2003 at 8:53 am

    #458668

    Try odbcping.exe. You can download it from microsoft website.

  • May 29, 2003 at 9:36 am

    #459043

    Is there a way to verify that an ADO connection object is "pointing" to a valid instance of SQL Server?

    For instance, to avoid opening and closing connection to SQL Server for every transaction, an object will

    open an ADO connection at the beginning of its lifetime and close it at the end.

    During the course of that object's lifetime, SQL Server may be restarted. In which case the ADO connection object

    is no longer valid. Is there a way to validate the ADO connection before actually using it?

    Andrej

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply