Re: Problems with Errors (Is this a bug)

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

I understand where you are comming from. But what if I wanted to write
something like QA. The MS tools don't let me do this without having to go
back to the deep dark ages of ODBC or maybe using SQLDMO! that is a giant
step backwards.

Also YOu obviously don't undestand all the issues.. WHat if you were calling
a proc and one step failed, but then the next step did 3 deletes and 2
inserts but the error of the first one prevents you from seeing this/..

BUG

"Marina" wrote:

> I don't think you understood my post.
>
> What QA can do is no relation to what ADO.NET can do. So you can't expect
> the 2 to do the same thing. So just because ADO.NET does not have the same
> capabilities or a different model of how it executes statements, does not
> mean it is a bug!!!
>
> ADO.NET does let you know that the error has occurred, so I don't see the
> problem. If you don't like the fact that you can not get the results of the
> second query, execute them separately.
>
> Additionally, ADO.NET should not be used for processing scripts. That is not
> what it is there for. If you need to be able to run arbitrary sql scripts
> that have GO statements, etc, you need to use SQL DMO.
>
> "rob lynch" <roblynch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:40360E45-2597-4D74-AE2D-4BFACCDB564F@xxxxxxxxxxxxxxxx
> >I agree (QA is a tool), but what QA shows is that something happens after
> >the
> > error...
> >
> > If I don't know that because ADO.NEt doesn't show it, it is a BUG in ado..
> > It is keeping information to itself and not letting the client know! That
> > shouldn't be up to ADO to filter this improtant infromtaion out!
> >
> > How can this be fixed or can we be certain we are being given the correct
> > result of a transaction...>?????????
> >
> >
> > Rob
> >
> >
> > "Marina" wrote:
> >
> >> ADO.NET is not the equivalent of query analyzer, don't expect it to act
> >> as
> >> such. They are very different, and you can't do everything with ado.net
> >> that
> >> you can in QA.
> >>
> >> Like you said, QA is a tool. So it is written to be able to do certain
> >> things.
> >>
> >> "rob lynch" <roblynch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:920C9104-2C1B-4508-90DA-BF5540A932F2@xxxxxxxxxxxxxxxx
> >> > Scenero:
> >> > Run a batch file..
> >> > Multiple Querys...
> >> > An error occours in 1 query and in QA all other querys will run and
> >> > return
> >> > results.
> >> > In dot net I can't get past the error..
> >> > ie
> >> > Select top 1 lastname from northwind.dbo.employees
> >> > raiserror ('Error Here',14,2)
> >> > Select top 1 firstname from northwind.dbo.employees
> >> >
> >> > In QA I would see Davilo - Error here - and Nancy
> >> > 2 recordsets / datatables and an error...
> >> >
> >> > In ADO.Net the best I get is the first Recordset(datatable - set of
> >> > records
> >> > - whatever you want to think of it as.....)
> >> >
> >> > If I use a datareader I end up getting a wonderfull error of
> >> > "A severe error occurred on the current command. The results, if any,
> >> > should be discarded."
> >> > As soon as I try to access the second recordset/set of records/group of
> >> > readonly rows.
> >> > It won't let me see the second recordset, it just dies at that point...
> >> >
> >> > Any clues as to how to get a valid result like QA are welcome.!
> >> >
> >> > TIA
> >> >
> >> > Rob
> >> >
> >> > PS this seems kind of buggy to me... If I shouldn't be able to get the
> >> > results in DotNet, why does the SQL Server tool let me?
> >> >
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Problems with Errors (Is this a bug)
    ... SQL DMO isn't guaranteed to stay the same and then you ... > second query, execute them separately. ... If you need to be able to run arbitrary sql scripts ... >> If I don't know that because ADO.NEt doesn't show it, it is a BUG in ado.. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Identity error?? Please help
    ... >> each table has an identity column. ... > It sounds like you've run up against the ADO bug of the year... ... Use GUIDs in place of IDENTITY ...
    (borland.public.delphi.database.ado)
  • Re: comparing distinct data
    ... Your code uses ADO to query an open workbook. ... BUG: Memory leak occurs when you query an open Excel worksheet by using ... The Microsoft OLE DB provider for Jet 4.0 is the provider of choice ...
    (microsoft.public.excel.programming)
  • Re: Seek problem in VB6 program
    ... Not a bug - it's the way messysoft designed ADO. ... What this means, is that a movefirst is a requirement for ADO, ... >>'Try a MoveFirst after opening the Recordset ...
    (microsoft.public.vb.database.ado)
  • Re: update 500000 records with adodb.recordset resize the mdb from 140M to 2G
    ... are you using access 2000 or + and ado less than 2.5 ... if so there is a bug that uses an entire page for 1 single record ... > I have an access database with one table ... > text and numeric fields are updated. ...
    (microsoft.public.vb.database.ado)