One easy way is to use MySQL on a server and their ODBC driver. No reprogramming required because the odbc link will come up just like a BDE alias.
There are only very small differences between paradox and mysql. MySQL has no trouble going to very - very big databases and will run for years without even a reboot. Rainer von Saleski wrote: > I have an application using BDE and Paradox tables that has overwhelmed > the capabilities of BDE and/or Paradox -- too many records -- in Delphi > 7. Translation: a file gets corrupted after adding a few 100,000 > records. Every time. > > I really have no desire to totally rewrite all the database access > routines (there are dozens and dozens). What is the least painful > alternative database type to use? I am familiar with SQL from web site > applications, but not in Delphi. > > All the file structures are static -- no adding or removing fields or > indexes during execution. The programs are written for a single user -- > no locking worries. In BDE terms, I tend to use IndexName, Active, > FindKey, FindNearest, Next, Prev, First, Last, Eoi, Edit, Insert, > Append, Post, Delete, the "magic" type-converting field variables; > DBGrid, DBNavigate, OnPost, and not much else. > > Suggestions will be much appreciated -- especially those that confine > most code revisions to the Data Module or other central location. > > Thanks, > Rainer > > > > _______________________________________________ > Delphi-DB mailing list > Delphi-DB@elists.org > http://www.elists.org/mailman/listinfo/delphi-db > > _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
