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 |
|
juicyapple
Posting Yak Master
176 Posts |
 Posted - 2008-02-18 : 23:10:41
|
| Hi,how to validate sql connection status is whether successful of failed (in terms of network) from asp.net? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-19 : 04:08:52
|
| You can open connection inside a TRY..CATCH block. If the connection is unsuccessful, you can catch the error details inside CATCH block.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
juicyapple
Posting Yak Master
176 Posts |
Posted - 2008-02-19 : 21:00:53
|
| means I need to do some DML query within the try block? |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
SQL connection status