Trying to get rid of BDE 1

[Jonah86]

Ugh. I know I should have bid a fond farewell to the BDE long ago...but it just seems so daunting.

My question is: What would the best rout be for converting? ADO? dbExpress? I've never used dbExpress but I have tried ADO. What are the benefits to each?

Also, am I going to have any issues if we ever move up from WinXP? Say to 7?

Thanks for your help folks!

 

[DjangMan]

ADO will be around for a long time. Easy to adapt your applications from BDE to ADO. Plus any Windows PC has ADO on it. dbExpress can run faster but you have to change your thinking about how you code your applications. dbExpress is typically about cached updates.

 

[Jonah86]

Thanks! Sounds like I'm converting to ADO.

I'm happy to heard there won't be any problem with newer version of Windows. I like Delphi quite a bit.

 

[roo0047]

Please read this entire quote before reading my comment: (below)

Microsoft's ActiveX Data Objects (ADO) is a set of Component Object Model (COM) objects for accessing data sources. A part of MDAC, it provides a layer between programming languages and OLE DB (a means of accessing data stores, whether they be databases or otherwise, in a uniform manner). ADO allows a developer to write programs that access data without knowing how the database is implemented. You must be aware of your database for connection only. No knowledge of SQL is required to access a database when using ADO, although one can use ADO to execute SQL commands. The disadvantage of this (i.e. using SQL directly) is that it introduces a dependency upon the type of database used.

It is positioned as a successor to Microsoft's earlier object layers for accessing data sources, including RDO (Remote Data Objects) and DAO (Data Access Objects). ADO was introduced by Microsoft in October 1996.

(source:

http://en.wikipedia.org/wiki/ActiveX_Data_Objects)

As a Delphi developer, I strive to not be dependant on M$ crutches and do my own work. There are too many tools and component sets available under GNU General Public License that are faster and far more intuitive. Sure, something can be said for easy. I would be interested in any tool that offered data .AsXML :

Personal favorite:

http://sourceforge.net/projects/zeoslib/

http://zeos.firmos.at/portal.php

Roo
Delphi Rules!