Re: ADO vs dbExpress

danielk1@xxxxxxxxx wrote:

Has anyone found any evaluations or conclusions on whether ADO or
dbExpress is the better choice for DB connectivity?

We are currently using SQL 2005 and ADO seems like a logical choice,
however, dbExpress seems to require more components to connect to the
DB: conneciton, datasource, data source provider, client data source,
and query, while ADO only requires connection and datasource and
table/query.

Speed-wise, I beleive them to be about the same and we do not have a
lot of traffic.

But if one is better/easier, I would surley like to know.

I already developed a couple things, relatviely easily, using ADO, but
wanted opinions on dbExpress.

We are using Delphi 2006 Developers Studio.

Thank you,

Daniel

as an addition to what Brian says, dbExpress uses unidirectional
cursors, a limitation that ADO has not.

--
Best regards :)

Guillem Vicens Meier
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages

  • Re: ADO vs dbExpress
    ... dbExpress is the better choice for DB connectivity? ... We are currently using SQL 2005 and ADO seems like a logical choice, ... ADO is a lot easier to work with Microsoft SQL server than dbExpress is. ...
    (borland.public.delphi.database.ado)
  • ADO vs dbExpress
    ... dbExpress is the better choice for DB connectivity? ... We are currently using SQL 2005 and ADO seems like a logical choice, ... We are using Delphi 2006 Developers Studio. ...
    (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: Regarding Database Connection
    ... How many types Database connectivity are there using ADO and give ... All data access is based on a series of layers of 'access' from software to ...
    (microsoft.public.vb.database.ado)
  • Re: Delphi books of intrest?
    ... I'll cover the Borland Database Engine, dbGo for ADO, dbExpress ... and the stand-alone TClientDataSet. ... Delphi, although ADO needs Delphi 5 or higher, dbExpress needs Delphi ...
    (borland.public.delphi.non-technical)