Checking for SQL existence???
I have a small application which makes a connection to an SQL DB and I am wondering if there was any
way to programatically check to see if the server is available or not prior to opening the connection.
I'm not sure if I'm making a whole lot fo sense here but this is basically what I'm running in to.
If I go to open the DB connection cn.open() but the SQL server happens to be down... then the app
will just hang for about 1 minute. I would like to know if there is anyway I can control this timeout and
have the application go elsewhere.
I no how to set the SQL timeout but that does not seem to address what I am running in to.
Any assistance with this would be greatly appreciaated.
Thanks,
Bob