I want to detect when connectivity with SQL Server fails, so i can fire an alert for the user.
Does anyone know a bit of code that will help me detect when connectivity with the SQL Server fails (SQL Server goes down, network cable is unplugged etc).
I try with:
If Conn1.State = adStateOpen Then
But it returns always true. :( also with cable unplugged!
Any help would be gratefully appreciated.