I wrote a short VB program that connects over my LAN to SQL Server 2000
(using ADO's Connection object). I'm polling the connection status at
regular intervals by getting the value of MyConnection.State, however, this
is not alwayz accurate. If, for example, I go to the NT server and stop the
SQL Server service (MSSQLSERVER) MyConnection.State does not change!!!!! It
stills thinks it's connected (State = adStateOpen) ... why???
How can I accurately determine if I'm connected to the server???
Rommel the iCeMAn