Re: SqlConnection.Open() Which ErrorCodes

Hi Henrik,
Thanks for your waiting.

I have spend the whole day searching on internet and documents, however,
doesn't found List which included all possible error number caused by
Open()/Execute***(). I also tried with Reflector. This doesn't help...

Sorry, for my curious, would you please kindly let me know why do you want
to get such Error Number list? If you just want to write some
trouble-shooting document for your end user, I think the information in
SQLException.error is enough.

For the entire error messages, I'm afraid the only way is that querying the
sys.messages system table for the message_id and text of SQL Server errors.
See the error messages topic in SQL Books Online. On the client side, see
the documentation in the .NET Framework Help for these classes:
SqlConnection.Open, SqlException, and SqlErrorCollection/SqlError, which
enables you to handle server-side errors. However, there must be a lot of
work for us.

I'm sorry if you feel this isn't really helping...
But, would you please let us know what your objective is? Maybe there is
other way to approach that without the Erro Number List...

Thanks again for your patience
Sincerely,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Loading