Determining if SQL is running from VB 6?

[svankley]

I have a need to know, for failover support, if a SQL server is running or not. I need to check every 10-50ms to see if the server is running and if not, switch to one of 26 others. I also don't want to have to wait for the 1 minute timeout if the machine is disconnected or the network is down. I know someone along the way has had this same issue, and I'd really appreciate any guidance or suggestions with this so I don't have to reinvent the wheel.

Thanks in advance,

Steve

 

[Ladyhawk]

You can use SQLDMO to connect to the SQL Server and check the status, ie, running, stopped etc. I can give you some sample code if you want.

Ladyhawk.
** ASP/VB/Java Programmer **

 

[svankley]

Yes, I'ld like to see this sample code.

Thanks,

Steve

 

[NoCoolHandle]

Ladyhawk,

I have been down the SQLDMO track before, and although it will tell you that it is down, using Status will take 20 seconds and produce an RPC unavailable error - if the server is not running. If the server is running, but the service is down, no problems. Everything works as expected and very fast.

(If you have had different experience please advise)

Ado gets 60 Seconds...

In the past I have used ping -n 1 server from VB and looked for the dos window to dissapear within 10 ms.. Which it usually does within 2 to 5 ms..

It seems OK, but it does have some overhead as you need to run the shell command to have it execute.

I have also played with a tcp connection and sending data, but this also seems less than optimal.


My 1c

Rob