Author
Topic: Paradox DataSet (Read 2638 times)

Has anybody persuaded this dataset to work on a Windows installation of Lazarus/Free pascal?Mine suggests it needs a DLL, which I have downloaded and placed in Windows\System32, but the dataset still reports the same error.

What tutorial are you following? Please, provide the link to it.What DLL have you downloaded and why haven't you put it in your applications folder instead of putting it in Windows\System32?If possible, please make a very small project showing the error and attach it zipped to this thread so we can help you better.

valdir - no tutorial, did not see the need - been using Paradox tables in Delphi as long as I've been using Delhpi (about 10 years)Attached are my project.lpr, unit1.pas files (as text), and a screenshot showing the error, which occurs when I click the active checkbox in the Object Inspector. I'm used to seeing errors here, BUT, they usually relate to the table itself, rather than the engine!!As to the location of the DLL I started off with it in the Lazarus path, but moved it when I first saw the error, the point being that Windows\System32 should be accessible everywhere. I believe there is still also a copy in the Lazarus directory, which should also be on the path.

Thanks for the info Valdir. I had already seen the topic 3107 - did not seem to help. Perhaps I should explain that I have a large collection of Paradox tables, having been a Paradox user far longer than a Delphi programmer - I go back to Paradox for DOS! Therefore, it seemed sensible to try and re-use these rather than starting from scratch. As as fall-back though, I wrote a quick, and dirty, Delphi app to export all my data as CSV files - yes, I still have access to Delphi, running on Windows XP, via Virtual box, but this is NOT a long term solution. As to my Lazarus, I believe it is the 32-bit version.

What stops you from migrating your old application in Delphi and Paradox to a new application using Lazarus and a real RDBMS (Relational Database Management System)?I suggested that you use Firebird as your database solution, but there are several other options.

Hi PatBayford,I migrated my old Delphi 6 Paradox DB's to Firebird last year and I used a different paradox dataset (tparadox-0.1.zip- look at sorceforge ). That worked fine with the pxlib.dll (from 1.10.2007) in the lazarus directory. The migration was easy. Just put the paradox dataset and the TSQLQuery on the form. During a loop assign the Paradox data to Firebird via SQL Insert like

Thanks again Valdir - the problem is, I don't have a single application, but quite a large set of them! It's more a question of getting access to the data for new applications, fortunately the CSV file solution has, at least partly, solved that problem. So, I already have steps 1 and 2 of your conversion strategy in palce.Thank you LuckyLynx for your comments - I have no experience at all with Firebird, but will look at it, as I do need a working RDBMS, and I absolutely hate Access! I will try the tparadox.zip you suggest