locking in ADO

From: Susan Leigh (magine_at_turtleflight.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 01:53:58 -0500

I've been trying for a long time to resolve a sporadic problem I have
with errors occuring when trying to update records in a MS Access
database, using ADO. Actually I finally resolved the problem after much
tweaking in an earlier version of the application, written in Delphi 5
and using third party ADO components (ADOnis). But now that I'm porting
to Delphi 7, I'm seeing those old errors again.

I'm using the BetterADO components since the standard Delphi 7 ADO
components were giving me some other problems which the BetterADO
components resolved.

The errors I'm seeing are either:

Could not update, currently locked by used 'admin' on machine 'TORTUGA'

(Tortuga is the computer's name.)

OR

Row cannot be located for updating, some values may have changed since
it was last read.

Is this a matter of trying to change too many records in rapid
succession? The database activity in my application all takes place
serially, so it doesn't seem like I could be trying to update a record
that was still open. Any if that were the case, then why would the
problem only occur with the newer ADO components?

I'm guessing the reason that the problem has resurfaced in Delphi 7 may
be that the old ADOnis components I used with Delphi 5 had more
adjustable parameters, that the components I'm using now lack. Still, it
doesn't seem that I'm trying to do anything that exotic...maybe I'm just
leaving something out? What kinds of things should I be looking for?

Relevant Pages

  • Re: Connection error to SQL Server
    ... > I think that de ADO components includes in the Delphi 7 currupts some part ... > of the .NET Framework ADO.NET components, ... > Dim conexion As OleDbConnection ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: So why all the Delphi 2006 gushing praise?
    ... I don't think Delphi 2006 is deserving of such outpouring of ... How to resolve such issues? ...
    (borland.public.delphi.non-technical)
  • Re: More not-so-cool Delphi 8 Stuff
    ... >Delphi/MSSQL with the ADO components? ... Of course will have to rewrite a lot of things,but your knowledge of the language is preserved,many of your routines are ... By reading the article at Swiss Delphi Center.its clear that those who have adopted the concept of optimistic locking by using client-dataset extensively will feel much more confartable ... times and I donīt blame Borland For That. ...
    (borland.public.delphi.non-technical)
  • Re: Delphi 8: Wheres my TADOQuery?
    ... > looking at all our code with the ado components and freaking ... though I think Borland really should have made a wrapper ... > Delphi: I'm afraid Borland is going to lose many Delphi devotees. ...
    (borland.public.delphi.non-technical)
  • Re: dbGo at BorCon
    ... > Anyone at the conf hear anything about dbGo (ie the ADO components) in the ... > upcoming versions of Delphi? ... How about additions for Delphi 8? ... dbgo is in DiamondBack (according to JK's presentation, ...
    (borland.public.delphi.non-technical)