Re: BDE vs ADO

From: Toon Krijthe (remove.this.krijthe.and.this.too_at_xs4all.nl)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 22:44:21 +0100

"Christian Charest" <ccharest@mtq.gouv.qc.ca> wrote in message
news:5ip%b.239$Xy3.859@tor-nn1.netcom.ca...
> Hi i am working on a application that uses BDE connections and i want to
add
> ADO connections instead... i wanted to know your opignion on this change
and
> if it is a good idea ?? i also wanted to know if the code as to be
drasticly
> changed in order to go from BDE to ADO...
We just did that and it definitely simplifies life. These days you should
only use the
bde if you are using paradox or dbase tables.
ADO works very well with msAccess. Althoug we found some minor differences
in
behaviour after the port to ADO. Something with caching as i recal, so
please build
some good tests before the port so you can ensure the behaviour has not
changed.
Unfortunately I have no experience with stored procedures.

HTH
Toon Krijthe

Relevant Pages

  • 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)
  • Re: Conversion from BDE to ADO
    ... I've noticed no performance problems with ADO and MSSQL. ... conversion). ... > I am currently experimenting with converting a quite large app from BDE to ...
    (borland.public.delphi.database.ado)
  • ADO and BDE interact on XP SP2?
    ... It uses the BDE ... indirectly to connect to a database. ... also optionally uses ADO to connect directly to the database for ... but of course any built in initialisation will have taken place. ...
    (borland.public.delphi.database.ado)
  • Re: Enhancing ADO Performance
    ... > currently have applications constructed to retrieve data from ODBC ... > worked with both because of the installation issues when using the BDE ... It seems that ADO ... of data and hooking to a DB grid, use a server-side cursor. ...
    (borland.public.delphi.database.ado)