SQL Server Connection Test

Question

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

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

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

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

asemrl SSC Enthusiast Points: 163 More actions · Answer 2

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