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.

 

[sherifffruitfly]

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/library/system.data.sqlclient.sqlerror(VS.80).aspx


There may be a way faster than this. Anyone?


hth,

cdj