whats the best database component to use

Sorry for the typos, typing on the phone is not always fun
<BDE is no good, don't use it>
<dbExpress is excellent and its what I use to connect to sql server and firebird with depart drivers

I'm not familiar with odac, I have never used it so I can't comment on it

@ ewangoya
>   "BEE is no good"

Some times BEE is good, otherwise we don't get honey :-)

@jimyX
LOL nice one
I'll get you somedaye

@Mahdi78
I don't know about best
Unidac is still communicating with OLE DB or ODBC, its just one more layer before you get to the database

i LIKE all the comments;

>>BDE is no good, don't use it
yes, it was dissolve, it if is good then they will never abolish it.

>>dbExpress is excellent and its what I use to connect to sql server and forebode with depart drivers
it is recommended by Embarcadero

>>ADO is also very good intact it is much faster than dbexpress since dbexpress has to go through an extra dll to communicate with the database and the drivers often come  free with the database
I agree with this

>>My best bet is to use ADO. But I am sure other people will have different opinions
But using ADO?   do you think,   we can connect to every kind of database models such as my_sql, sq_lite, ms_sql, oracle,  teradata, db2 or 3?   I think ADODB component can only be used to connect using ms_access data model?
...
...
>>The best component it is Unidac from devart.com
Yes, I've seen this chart a long time ago, it is.
All most the same as dBexpress.
..
..
>>otherwise we don't get honey :-)
now, this is a joke, anyway, congrats to jimyX in top 25 in delphi hall of fame,  too early.
...
...
>>I'm not familiar with odac, I have never used it so I can't comment on it
Actually, epasquier and geert recommends to use it, they said it's fast and good.
I think it's from DevArt too AS dbExpress from?  I don't know if there is from Oracle it self.

...
...
>>Unidac is still communicating with OLE DB or ODBC, its just one more layer before you get to the database
yes, slows down the database system? a little maybe,  nice comment ewangoya.

ADO can connect to all databases as long as you a have an OLE DB Provider or ODBC driver for that database. So all the databases you mentioned can be accessed through ADO including the ones shown in the odac diagram by Mahdi78

>>ADO can connect to all databases as long as you a have an OLE DB Provider or ODBC driver for that database
yes the driver itself slows down the database system.  ODBC is slow.  OLEDB is fast.
...
...
>>The advantage of DBExpress over ADO is that DBExpress supports multi-platforms.
I think they are both same,  not with multi-platform.
ADO only individualized the drivers needed to connect.
dBExpress has it's own internal drivers for different data models.
...
...
>>ODAC is a component for fast direct access to Oracle.
Yes, it's from devArt, so it will be installed on dbExpress?

I think jimyX is in favor of dbExpress, aDO for ewangoya, unidac for madhi.


>>
Regarding the best database component, there are many factors to consider when selecting DB components.
What factors? like?


Ok; I got to close this by monday, good comments fellows.

thanks

Oh, iNTERbASE on the palette?
A special database component palette using the interbase data model ALONE.?

BDE 2/10, ADO3/10, IB 3/10, ODAC 9/10
but that's just my opinion

BDE only gets 2/10 because it didn't stick around anymore ... :)

ODAC 9/10?
what?
odac access from dBexpress
so dBexpress incharge of odac?
I don't really know what will happen to the palette if you install odac on delphi.

no, odac from devart

Points increased for many assistance.


But dBexpress is a devArt project? isn't it?
...
...
>>no, odac from devart
You meant to say that after installation of odac?, it will build another palette for just odac?
..
..
>>I'm committed to dBExpress, using it for ORACLE 10g and 11g database.
>>It is  straightforward, powerful and flexible...
I believed this one; with oracle, but the oracle driver is ODAC itself?  if NOT where does that came from<the oracle from dBexpress I meant>?

The comments are great.

There is also, core labs odac for Delphi, I'm not sure if is real.

The comments are graded level.


thank you

core labs was taken over be devart.
They are 1 and the same

toink;

thanks geert