How to know if SQLExeception is connection problem

[Dan Holmes]

if i have a sqlexception error how can i tell if it was a failure to
connect to the db or a problem with the SQL? I want to handle
connection failures a different way.

dan

[sloan]

There are ErrorNumber(s) .. which mean different things.


"Dan Holmes" <da*******@bigfoot.comwrote in message
news:u6**************@TK2MSFTNGP05.phx.gbl...

if i have a sqlexception error how can i tell if it was a failure to
connect to the db or a problem with the SQL? I want to handle
connection failures a different way.

dan

[sherifffruitfly]

On Mar 8, 12:17 pm, Dan Holmes <[e-mail]:

if i have a sqlexception error how can i tell if it was a failure to
connect to the db or a problem with the SQL? I want to handle
connection failures a different way.

dan

SqlException contains at least one SqlError. SqlError contains a
Number property, identifying the error.

All SqlError numbers and descriptions are in:

select * from master.dbo.sysmessages;
More info in: http://msdn2.microsoft.com/en-us/lib...or(VS.80).aspx
There may be a way faster than this. Anyone?
hth,

cdj