Search code examples
databasedelphiadodbx

ADO or DBX using Delphi

Which is better (and for what reasons) to use to connect to MS SQL, Oracle or Firebird from a Delphi Win32 application -- ADO or DBX (Database Express)?

Both allow you to connect to the major databases. I like the way ADO does it all with a connection string change and the fact that ADO and the drivers are included with Windows so nothing extra to deploy (it seems, correct me if I'm wrong).

DBX is also flexible and I can compile the drivers into my app, can I not?

I really am keen to have a single source if possible, with the ability to vary databases depending on the customer's IT department/preferences.

But which is easier to program, performs better, uses memory most efficiently? Any other things to differentiate them on?

Thanks, Richard

Solution

  • ADO is simple to use and is there, you only must make sure to install the correponding client driver in the client side.

    I found DBX more flexible and it is better integrated within IDE and another technologies like DataSnap.

    For the same purpose than you, I have used DBX with Third Party Drivers from DevArt. You can compile the drivers with your application if you buy the drivers sources.