Re: ADO error OLE error 8004D00E

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 01/08/04

  • Next message: Glynn Owen: "Re: Default field size of ADO to Excel" 
    Date: Thu, 8 Jan 2004 22:55:32 +0300

    It is XACT_E_NOTRANSACTION, defined in transact.h - Unable to commit the
    transaction because it had already been explicitly committed or aborted.
    Error can be related to DBMS transaction as well as COM+ transaction.

    //------------------------------------------
    Regards,
    Vassiliev V. V.
    http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
    http://www.oledbdirect.com - The fastest way to access MS SQL Server,
    MS Jet (Access) and Interbase (through OLEDB)

    "Janaki" <jthapliya@quadramed.com> сообщил/сообщила в новостях следующее:
    news:3ffdaa86$2@newsgroups.borland.com...
    > Hi,
    >
    > I am getting an exception which says "OLE error 8004D00E" when I try to
    run
    > a stored procedure that inserts into a table and returns a recordset.
    > I cannot find the description of the error anywhere on the web. Is any one
    > familiar with this error?
    >
    > I am running Delphi7, MDAC version..2.8 on windows 2000 with SP 4..
    >
    >
    > Thanks
    >
    > Janaki
    >
    >

  • Next message: Glynn Owen: "Re: Default field size of ADO to Excel"

    Relevant Pages

    • Re: Determining column names and types of recordset returned by stored procedure
      ... There is no such contract to define what a stored procedure will return. ... > I understand that a proc may return no recordset, one recordset, or ... > built in procs) to get such info about a table as follows. ... > transaction and passing all null parameters, ...
      (microsoft.public.sqlserver.programming)
    • Re: Connection types and speeds
      ... The memory used by holding the connection open is not ... All recordset inserts seen to consequently have 0ms execution time, ... actually written to the database while the code has regained control ... RecordsetClone of a form) when a transaction was rolled back, ...
      (microsoft.public.access.queries)
    • Re: commit or rollback a transaction without first beginning a transaction
      ... I understood the opposite; that when a recordset ... the recordset before entering the transaction, ... > what happens with a Jet recordset. ... >> a single connection, so when SQLTransact is called, all statements on the ...
      (microsoft.public.access.modulesdaovba)
    • Re: Delete event not followed up with BeforeDelConfirm or AfterDel
      ... I take it you are trying to wrap your own transaction around all the ... inserts, edits, and deletes in both a main form and a subform. ... decision to either commit or rollback. ... recordset within that transaction, open a form, and assign your recordset to ...
      (microsoft.public.access.forms)
    • Re: "cant open any more tables"
      ... Assign the workspace variable, then the transaction, ... If you do need to close a recordset, ... >> updates every time through the loop. ...
      (microsoft.public.access.modulesdaovba)