Conversion from BDE to ADO

From: John Faris (johnfaris_at_nospam.hotmail.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 10:50:10 -0000

Hi all.

I am currently experimenting with converting a quite large app from BDE to
ADO. It accesses a MS SQL 2000 database, and before I commit and jump
headlong into this I wonder if there are any major issues to be aware of?
One of the main benefits I am hoping for is better multi-user detection
capabillity e.g. if one user changes a record another has open and then the
other user tries to change they get an appropriate error message. I have
found BDE support for this a little flakey at best. Are there any setting
changes from the default on TAdoQuery or TAdoConnection that I should
definitely make? Finally I have seen a fair bit of discussion around
suggesting that ADO will slow my app down, is this true?

Many thanks for any input.

John.

Relevant Pages

  • BDE to ADO
    ... I am somewhat confused regarding defining ADO connections. ... With BDE I do not have to code server and database ... information in the app. ...
    (borland.public.delphi.database.ado)
  • Re: BDE to ADO
    ... > I am somewhat confused regarding defining ADO connections. ... With BDE I do not have to code server and database ... > information in the app. ... If you want to store the connection info outside of the app, ...
    (borland.public.delphi.database.ado)
  • Re: Run ADO/OLE DB from a CD-R
    ... > I need to get my VB6 app. ... > installing any files onto the host machine, or making any registry entries of ... > also have had Visual Studio installed, however on all other machines, the ADO ... Do you mean the bound-control 'ADODC' when you say 'ADO control'? ...
    (microsoft.public.data.ado)
  • D7 & ADO with ASA9: EOLEException & Multiple-step error
    ... If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName.AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at ... I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything and rebooting - so far so bad... ... The BDE version has been working with identical data for nearly 10 years without a hitch - it still is. ...
    (borland.public.delphi.database.ado)
  • Re: BDE support??
    ... > We have an application that is using controls descended from TDatabase, ... > we'd like to convince the higher ups to ditch the BDE and move to ADO. ... Very nice for unit testing, ...
    (borland.public.delphi.non-technical)