Re: ADO.NET Not Returning Error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 18:08:44 -0400

I've tested this a bunch, can't find the documentation so it's a bit
counterintuitive, but it seems to be the case nonetheless.
"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
news:%232yGVbvLEHA.2976@TK2MSFTNGP10.phx.gbl...
> I'm using it with both the way you presented it and the one that QA can
> parse. Here's the deal. when you hit dr.Read you blow up if you use the
> incorrect one. You're fine otherwise. I'm catching the exception each
time
> as soon as I try read. If I do it with the cast, all is good.
> "achobbs" <anonymous@discussions.microsoft.com> wrote in message
> news:57AE5B56-CADE-4D3C-8B70-9D51FC664527@microsoft.com...
> >
> > **** Are you sure you aren't eating the exception? you are calling
what,
> > **** cmd.Execute??? Infomessage is only fired for certain severities so
> you
> > **** can'[t count on it.
> >
> > I am calling SqlCommand.ExecuteReader and trapping the call in a try
with
> a catch (Exception e) so the error should be captured if there is one. I
> also get other info messages (not that this should show an info message),
> but I get nothing back from ADO for this statement. No Exception, No
> InfoMessage, and No DataReader. ADO should at least give me an error or
> infomessage back since the statement essentially fails because of a
> conversion error.
> >
> > **** I used this too and it worked fine:
> > **** select
> > **** 'CategoryID = ' +CAST( c.CategoryID AS VARCHAR)
> > **** from
> > **** northwind.dbo.Categories c
> >
> > Yes, the query is wrong but the situation is that we let people type in
> queries and when a user types in a query of this format, they don't get
> anything back and think they just didn't have any results when the actual
> reason is that an error was in the sql statement that we weren't notified
of
> by ADO.
> >
> > Thanks,
> >
> > Ashton Hobbs
> > http://www.mssqled.com
> >
> >
>
>

Relevant Pages

  • Re: ADO.NET Not Returning Error
    ... a catch (Exception e) so the error should be captured if there is one. ... also get other info messages, ... but I get nothing back from ADO for this statement. ... queries and when a user types in a query of this format, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET Not Returning Error
    ... > a catch (Exception e) so the error should be captured if there is one. ... > but I get nothing back from ADO for this statement. ... > queries and when a user types in a query of this format, ...
    (microsoft.public.dotnet.framework.adonet)
  • D7 & ADO with ASA9: EOLEException & Multiple-step error
    ... If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName.AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at ... I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything and rebooting - so far so bad... ... The BDE version has been working with identical data for nearly 10 years without a hitch - it still is. ...
    (borland.public.delphi.database.ado)
  • Re: ADO seems to eat errors
    ... It seems that ADO interprets an exception raised within a SELECT-able ... I start with a very simple stored procedure which returns only ... Recordset has 1 row with 1 column. ...
    (microsoft.public.data.ado)
  • Re: Problems using ADO with multi threading
    ... ListIndexOutOfBounds is VCL (not MS ADO) exception, ... create new data module instance for every thread. ...
    (borland.public.delphi.database.ado)