1

Currently I have an old Delphi project using BDE to connect to Paradox.

We want to investigate whether ADO can be used to replace the BDE but still use Paradox for Delphi version 10.2 Tokyo.

So please advise me that Delphi 10.2 supports Paradox Database? If so please give advice on replacing the BDE to ADO?

Thanks & Best regard

Toàn Trịnh Bảo
  • 13
  • 1
  • 5

1 Answers1

1

A Microsoft ODBC driver for Paradox databases comes with Windows, so you can certainly connect to Paradox tables using ADO and ODBC. See the 32- and 64-bit ODBC administration apps under Control Panel | Administrative Tools, and in particular its Drivers tab.

To create a simple Paradox + ADO app:

  • Use Windows' ODBC wizard to create a system- or file-DSN that uses the MS ODBC Driver for ODBC to connect to the Paradox table.

  • In your Delphi app, use a TAdoConnection to use e.g. the OLE DB provider for ODBC to use the DSN and a TAdoQuery to do a SELECT * from the P'Dox table.

See my answer here

BDE to ADO conversion in DELPHI 5

for a way of converting from BDE to ADO to access Paradox tables. Btw, once you have access to your Paradox data via ADO, it is straightforward to replace Paradox with a proper, robust RDBMS.

Recent versions of Dephi, including Tokyo, come with a very capable alternative DB-access library called FireDAC, but:

  • It has a much steeper learning curve than ADO.

  • Its author no longer works for Embarcadero, so with their numerous other lay-offs, FireDAC may become an "evolutionary dead-end."

  • Being from Embarcadero, it does not have the "safety in numbers" that comes with using MS's tried and tested ADO.

MartynA
  • 30,454
  • 4
  • 32
  • 73
  • Calls for speculation. EMBT's "investment" in FireDAC or any other technology offering, can't simply be dependent on the presence of a single employee. – Freddie Bell Jul 18 '18 at 08:55
  • @nolaspeaker: Considering they hired him when they brought it in-house, I'd say his departure is rather telling. Anyway, given the choice of the likely future of ADO v. FD, I know which one my money is on. – MartynA Jul 18 '18 at 09:02
  • @MartynA: We tried creating a DNS file. But when making a connection, an error message "[Microsoft] [ODBC Paradox Driver] Could not open Paradox.net" appears. Please give me some advice. Thank you – Toàn Trịnh Bảo Jul 19 '18 at 01:52
  • Have you tried googling? This is the first hit: https://stackoverflow.com/questions/45022784/could-not-open-paradox-net Remember that Paradox pre-dates modern versions of Windows which define where a user does and does not have write permissions on files. – MartynA Jul 19 '18 at 05:54