Hi There
I just want to use ruby script to detect if the MS SQLserver works
well/status, beside use “connected”, is there any other better method?
thanks.
Hi There
I just want to use ruby script to detect if the MS SQLserver works
well/status, beside use “connected”, is there any other better method?
thanks.
you can try to run some specific query that results a specific result to
make sure the server is serving data.
what data do you need on the server?
Eliezer
Thanks for your reply, actually, I just want to know if this sql server
is live well or locked.
Edward
what locked means? Locked on a firewall level?
if so you can use the tcp-ping or just plain TCPclient socket and verify
it almost the same way you have done.
it will just make it in a lower level that requires only socket and not
dbi.
Eliezer
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.