Re: SqlConnection.Open() Which ErrorCodes

Hi Wen,

Thank you for your reply.

I would just like to show a decent error messsage to the user if something
goes wrong during the connection phase.

Cheers
Henrik.

"WenYuan Wang [MSFT]" <v-wywang@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:eaXOOTNtHHA.2312@xxxxxxxxxxxxxxxxxxxxxxxxx
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.



.

Relevant Pages

  • Re: SQL Adaptor - Timeout
    ... I have changed the host 'Max. number of message engine threads per CPU. ... to be 3 instead of 20 and I have the same error messages. ... Server stored procedures using SQL Server Adaptor. ...
    (microsoft.public.biztalk.general)
  • Re: Passing a null value as date to SQL
    ... When passing value to a SqlParameter then you have to use DBNull.Value. ... "amber" wrote in message ... > I'm using VB.NET and SQL Server. ... > I'm getting error messages not matter what I try. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Replication file sharing violation
    ... It appears from the error messages that you have not shut down an object ... that is accessing the database. ... accessing SQL Server CE is still running. ... > proceeding time will succeed also even if not in step mode. ...
    (microsoft.public.sqlserver.ce)
  • Re: documenation for .NET Data Provider for SQL Server errors
    ... > I was trying to find documenation for the error messages and the ... > provider for SQL Server. ... > The following is the message when the provider times out ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlConnection.Open() Which ErrorCodes
    ... sys.messages system table for the message_id and text of SQL Server errors. ... See the error messages topic in SQL Books Online. ...
    (microsoft.public.dotnet.framework.adonet)