Multiple Step Operation Generated Errors - Check each status value

From: Ryan (ryanofford_at_hotmail.com)
Date: 02/28/05 

Date: 28 Feb 2005 07:06:43 -0800

I've seen that this appears in this NG a lot. I've now joined the list
of frustrated people with this error message. I've tracked it down to
what I believe is an ADO error.

If anyone knows how to fix it, or has any pointers to what the solution
is, I would greatly appreciate it.

It's appeared recently in my app and I'm not aware of any changes that
could have caused this. What I have done is create a new form, ADO
connection, ADO Query, Dataset and Grid with the bare minimum to get to
the data. The problem is still there and has rendered my almost
finished app pretty much useless (unless I find a way around this).

I've seen a wide variety of potential areas that this could come from
and understand that there are a few errors that are happening, hence
the 'generic' message. When debugging, I get this a message saying it
is an EDatabase Error.

I've tried everything I can throw at it. Different development PC,
different server. Different copy of the data. Different connection.
Different components (inc Form). Given it to another developer. I've
tried trapping the error every way I can think of. Everything. It still
pops up.

I can edit the data directly in the table in SQL (7) and can change the
value in the field through code without any problems. Yet, when I try
and do this through even a simple TEdit component, it throws the error.
There are no triggers on the SQL table, no default values (bar an
identity field which I have removed, tested and re-added), no BLOB
fields. Nothing that would indicate the problem.

I can't seem to trap the error and I am completely stumped.

Is there actually a fix for this ?

Ryan

Relevant Pages

  • Re: Pessimistic locking with approles.
    ... The "fix" is to disable connection pooling in ADO in the connection ... security or SQLS security, and it has nothing whatsoever to do with ... SQL Application Role Errors with OLE DB Resource Pooling ...
    (microsoft.public.sqlserver.security)
  • Re: SQL incorporation with Excel
    ... Excel 2002 VBA by Bullen, Green, Bovey and Rosenberg has a fairly good ... Set a reference to ADO 2.7 in your vb project. ... connection string to find the correct way to connect. ... Our accounting system uses an SQL ...
    (microsoft.public.excel.programming)
  • Re: Error -2147168227 Cannot create new transaction because capacity was exceeded.
    ... Try to run SQL profiler, which ships with SQL Server to see how many ... > object and there is only 1 instance per application of the connection ... Prior to that I've just closed the ADO recordset object. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... I am trying to improve a VB6 app that accesses SQL Server data via ADO ... The connection that invokes the Execute method is created, opened, ...
    (microsoft.public.vb.database.ado)
  • Re: CoInitialize failure with many processes
    ... directly communicate with the SQL server. ... _connection object (apparently an ADO object, ... You can use the SQL Server Profiler to examine the number of connections ...
    (microsoft.public.win32.programmer.ole)