Re: documenation for '.NET Data Provider for SQL Server' errors

Tech-Archive recommends: Fix windows errors by optimizing your registry

Okay so the errors are basically Exceptions, and what I'd recommend is to
pick up a tool like Reflector and try and understand the exception structure
first.

Many of these errors donot have error numbers because they are exceptions.

Once you filter out the exception structure, then you can segregate all the
errors raised by the underlying Sql Server binaries under SqlException, and
those you can get a list from SQL server books online.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
----------------------------------------------------------------------------
---------------

"Vikram Vamshi" <vikram.vamshi@xxxxxxxxxxxxxxxxxxx> wrote in message
news:u6P6qernFHA.3920@xxxxxxxxxxxxxxxxxxxxxxx
> I was looking for the errors in ADO.NET 1.1 (specifically the ones for the
> sql server provider)
> Errors like 'Time out expired' and initiated from the client side.
> --
> Vikram Vamshi
> Database Engineer
> Eclipsys Corporation
>
> "Sahil Malik [MVP]" <contactmethrumyblog@xxxxxxxxxx> wrote in message
> news:ONpxUQrnFHA.3920@xxxxxxxxxxxxxxxxxxxxxxx
> > Okay, before I can answer the below, I need to ask you another question
> > :-)
> >
> > Are you talking about errors that occur in TSQL? (Because that is what
> > kinda
> > sounds like from your description - Error Numbers i.e), or are you
talking
> > about Errors that occur in ADO.NET?
> >
> > Also, if it is ADO.NET, then are you talking about ADO.NET 2.0 or 1.1?
> >
> >
> > --
> >
> > - Sahil Malik [MVP]
> > ADO.NET 2.0 book -
> > http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
>
> --------------------------------------------------------------------------
--
> > ---------------
> >
> > "Vikram Vamshi" <vikram.vamshi@xxxxxxxxxxxxxxxxxxx> wrote in message
> > news:#LW$hAqnFHA.3380@xxxxxxxxxxxxxxxxxxxxxxx
> >> Hi,
> >> I was trying to find documenation for the error messages and the
> >> corresponding error numbers for the errors that are raised by the .net
> > data
> >> provider for SQL Server.
> >>
> >> For example:
> >> The following is the message when the provider times out
> >> Timeout expired. The timeout period elapsed prior to completion of the
> >> operation or the server is not responding.
> >> and the corresponding error number is:-2
> >>
> >> I was trying to get a list of all the possible errors along with their
> > error
> >> numbers, so that we can handle them in our code if it is appropriate.
> >> It would help us a lot if someone can point me to the documentation.
> >>
> >> Thanks in advance.
> >> --
> >> Vikram Vamshi
> >> Database Engineer
> >> Eclipsys Corporation
> >>
> >>
> >
> >
>
>


.