Posted on 2004-11-25
Last Modified: 2013-11-23
Should I use ADO or BDE when I connect to an Oracle 8.x database. My Delphi program is supposed to able its user to view, edit, and add data in a table.
Question by:solhronn
    LVL 27

    Accepted Solution

    defintivly ADO or a native ThirdParty Tool, but no BDE (is outdated, never supported)

    meikl ;-)
    LVL 17

    Expert Comment

    Agree with meikl ;-)
    LVL 17

    Expert Comment

    by:Wim ten Brink

    I have done both in my past, btw. They both have some nasty issues that are a bit difficult to solve. But Borland isn't updating it's BDE version anymore, in favout of other techniques. If you compare both the BDE and ADO, then you won't find many differences, but ADO is more flexible to work with.

    Grant points to Meikl, btw. ;-)
    LVL 13

    Expert Comment

    yup... ADO, no discussion about it
    LVL 14

    Expert Comment

    no no... BDE? noooooo....

    ADO all the way, definitely! ;-)
    BDE is too klunky, bogs down deployment...

    Well, if you are not going to change your database vendors, another alternative is to go for Native or Direct Access components for your specific database... will generally be faster, performance-wise... but it ties you down to that particular database vendor...
    LVL 17

    Expert Comment

    by:Wim ten Brink
    Still, it amazes me... About 8 years ago, everyone considered the BDE the ultimate solution for database development. It was what made Delphi into what it is today: a great RAD tool. Before the BDE, database development was quite difficult. But with the BDE, the greatest dummies could even write database applications...

    But in all those years, it never improved like Microsoft was improving it's own database support. MS also had the advantage that they could make it part of the operating system and/or deliver it with MS Office to every Windows user. The BDE, wonderful as it was, slowly turned into a bloated concept, since "MS database tools didn't need to install any database drivers". (ADO was already installed with Office or some other MS product.) Furthermore, Borland just dropped the support for it since the BDE is a bit too limited to a single platform.

    Borland now has DBExpress as a replacement for the BDE. A bit more flexible but not as stable as ADO. Less bloated than the BDE too but with a limited support for certain databases. DBExpress has been set up as a platform-independant system thus you code could be ported to Kylix, if need be. But Kylix seems to be a dying product and thus it becomes questionable if you're ever going to be able to port your code...

    Third-party components are fine too, in many cases. It's just a bit difficult to find some good ones. Currently I'm using FlashFiler right now from TurboPower because it doesn't require any external DLL's or drivers or whatever. And it's definitely built for client/server development through TCP/IP. But this too is a bit of an old product. And it's not easy to set up a good environment for it. ADO just saves you a lot of trouble if you want to develop quickly.

    Expert Comment

    I find ado easier to deploy...bde requires installation of the bde engine and setting up the location of the database (or alias)....

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
    Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now