Re: Selecting Databases

From: Simon Hooper (simon_at_simonhooper.co.uk)
Date: 01/06/04


Date: Tue, 6 Jan 2004 16:51:48 -0000


> I want to change my fondemental base from BDE to one another Technology,
> Which Technology recommended, dbExpress or ADO?
> What are Borland Compnay Poletics for supporting these technologies?

The BDE is not recommended for new projects now, which implies you are going
in the right direction.

dbExpress is lightweight, but has one way cursors. This makes it good it
for loading ClientDataSets, but not for using the dbExpress datasets
directly. If you are using CDSs and there is a driver for your database,
this is the way to go.

ADO is fully featured and great for the Microsoft databases SQL Server and
Access. It is also a reasonable option if you want to use ODBC.

To complicate matters I see ADO has been dropped in D8 (see other threads in
this newsgroup)

Good luck
Simon



Relevant Pages

  • Re: dbGO for .NET (aka ADOExpress) - dont hold your breath
    ... (Is going from ADO to ADO.net that difficult. ... When ADOExpress came out in D5, I pretty much abandoned the BDE, ... and the component architecture is pretty ... If I had moved my architecture to dbExpress, ...
    (borland.public.delphi.non-technical)
  • Re: ADO or DBExpress?
    ... > We've been struggling for a while to figure out if we need ADO or DBExpress ... Currently we're using BDE components. ... I use dbExpress for some of my personal stuff. ... If ease of development and reliability is ...
    (borland.public.delphi.database.ado)
  • ADO performance
    ... database and ADO is 200 times slower than dbExpress or BDE. ... The persistence framework get the results in a query and after it assigns ...
    (borland.public.delphi.database.ado)
  • Re: dbExpress als Alternative für FIBPlus?
    ... und Oracle 9i mit dbExpress gearbeitet und war durchaus angetan. ... habe zwar auch gute Erfahrungen mit ADO und ADO.Net für den Zugriff auf ... OLEDB-Treibern für den Zugriff auf FireBird mittels ADO gemacht hat, ... > das ein Vorteil?), die Dokumentation scheint gut zu sein, es gibt ...
    (de.comp.lang.delphi.datenbanken)
  • Re: DAO vs ADO
    ... ADO will be around for a while, but it's definitely not the way of the ... wouldn't necessarily recommend new development in deprecated ... Access isn't a deprecated technology ...
    (microsoft.public.access.conversion)