delphi7+personal oracle8

Hi, could u tell me what is the best way to connect to oracle database from delphi application.
Who is Participating?
choinierepConnect With a Mentor Commented:
With Oracle 8 you have several options.

Options that come with Delphi:
1. BDE:  I find it somewhat slow compared to other solutions that come with Delphi, but reliable.  (Note: Borland has discontinued BDE)
2. dbExpress:  This is very fast.  (Note: the dbExpress driver is some what buggy.  I would purchase a replacement driver from Corelabs (
3. ADO:  I find this one also slow (slower then BDE), but reliable.  Make sure you have the lastest drivers from Microsoft.  (    Look for MDAC downloads)  

Options that you must purchase:
There are a lot of options here.  I use the dbExpress driver from Corelabs (, because I use multiple database and don't what to lock myself into oracle only.  If you don't care about locking yourself in then take a look at Oracle Data Access Components from Corelabs (  I would say this is the best method of accessing Oracle hands down. It is the fastest options and takes advantage of all of Oracles features.   I have not used any other options, but you can look at this site for more info about other options.(
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.