CancelBatch and OLE Error 80040E20

From: David Rueter (nospam_drueter_at_assyst.com)
Date: 07/27/04 

Date: Tue, 27 Jul 2004 10:46:18 -0700

I have a TADOStoredProc bound to data aware controls. (Happens to be
Intraweb controls--though I don't think that's relevant).

I have written an event handler for the WillChangeRecord event that takes
the updated values from the dataset, passes them to a stored procedure,
executes the stored procedure, then calls CancelBatch.

This seems like its should work, but I get an exception on the call to
Dataset.CancelBatch:

Project Test.exe raised exception class EOleException with message 'OLE
error 80040E20'. Process stopped. Use Step or Run to continue.

However, if I handle this exception and look at the
Dataset.Connection.Errors collection, Errors.Count = 0--IOW ADO is not
reporting any specific errors.

Delphi 6 Enterprise, Update Pack 2.

Any ideas what this error means / what I'm doing wrong? Any suggestions on
a better approach to what I am trying to do?

TIA,

David Rueter
drueter@assyst.com

Relevant Pages

  • Re: Timeout on populating a datagrid
    ... I'd review the stored procedure SQL in a query tool and see how long ... An unhandled exception occurred during the execution of the ... >Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)
  • SqlDataAdapter.Fill returns results of previous command
    ... This code executes successfully at certain points in the application, ... I don't know what the cause of this exception is yet, ... stored procedure was indeed executed on the database. ... The trace shows that the last action on the db was the stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Session_End event, System.NullReferenceException
    ... database table that is used to log user sessions. ... The stored procedure executes successfully, and I can see the updated data in ... an exception is being generated by the code that I'ved added to ... through an execution of the code that led to the exception. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Ignore SQL Server 2000 store proc errors and still get results?
    ... catch (Exception ex) ... > You definitely don't want to do 30 round trips by handling the logic ... > temp table in your stored procedure to handle the collection of valid ... >>> expensive in both server and client code. ...
    (microsoft.public.dotnet.framework.adonet)
  • Random Timeout Exceptions
    ... Let say we have the following stored procedure which returns many records. ... namespace TestApp { ... "*" in application output means catching this exception. ... Usual output is: ...
    (microsoft.public.dotnet.framework.adonet)