Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
liangtp@hotmail.com
Starting Member
27 Posts |
 Posted - 2008-10-23 : 22:37:50
|
| Hi,My vb client is a loop that contantly accessing the SQL server. What is/are the better ways for the client to detect that the SQL server is up and running, before proceeding.Currently, if my SQL statements executed and returns an error, I assume that the SQL Server is down. Thanks. |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2008-10-24 : 03:45:02
|
| Use SMO/DMO to get list of network servers that are available currently and check whether your server is in the list. Google SMO or DMO. I think you can use anyone of the object model. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-24 : 03:53:49
|
In your connectionstring, set connection timeout to a low value, 2 second or so.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
How client detects SQL Server service is up?