Using ADO in a Delphi application

About ADO and Delphi

RecordSet.Open('SELECT * FROM TableName', DSN, adOpenDynamic, adLockOptimistic, adCmdUnspecified) ;

As business applications have become more sophisticated, the ability to quickly access and deliver data from various sources has become an essential requirement in today's software. We know that Delphi database application developers can access various types of databases using the BDE technology.
Let's take a quick look at one of the non-BDE approaches.

Universal Data Access with ADO

Microsoft's Universal Data Access (UDA) is designed to provide developers with a single, easy-to-use interface for accessing data. At the heart of this concept is OLE DB, a set of system-level COM interfaces that provide a uniform method of retrieving data regardless of its format or where it resides. OLE DB provides high-performance access to any data source, including relational and non-relational databases, email and file systems, text and graphics, custom business objects, and more. ActiveX Data Objects (ADO) is an object-based interface to OLE DB that works with any language that supports COM/ActiveX objects. ADO provides consistent, high-performance access to data, whether you are creating a front-end database client or middle-tier business object using an application, tool, language or even an Internet browser. ADO (version 2.1) is included as part of the Microsoft Data Access Components (MDAC), along with OLE DB and ODBC.

ADO is language-neutral, enabling you to use it with any programming language that supports COM, as Delphi does.

A Beginner's Guide to Delphi Database (ADO) Programming

This free online course is perfect for Delphi database beginners as well as for those who want a broad overview of the art of database programming with Delphi.
Developers will learn how to design, develop and test a database application using ADO with Delphi. This course focuses on the most common uses of ADO in a Delphi application: Connecting to a database using TADOConnection, work with Tables and Queries, handle database exception, create reports, etc.

If you are looking for more articles and tutorials, you'll find several on the next page ...

Improve and learn programming with ADO and Delphi using the following technical articles and tutorials:

Free Delphi Database Programming Course
Free online database programming course for beginner Delphi developers. Focus on ADO techniques. This online course is perfect for Delphi database beginners as well as for those who want a broad overview of the art of database programming with Delphi.

ADO: Delphi Reference Library
ADOExpress Step-by-Step-from-Scratch Tech Notes, ADO Resources, ADO Tips.

Features: UDL files -- Microsoft Data Link Files; DBF Files -- With and Without ADO; Delphi 5, ADOExpress, Access and Images; SQL Query Using ADODataSet; ADO Master/Detail and File Locking; Running ADO Applications in Windows 95; Briefcase: UDL and ADTG; ...

Data access dilemma
With Delphi 5 programmers are faced with the choice of using the BDE or ADO for database access. Typically, the answer to the question "Which database technology should I use?" is "It depends."

Implementing OLAP in Delphi Applications
"In this article, we will talk about using ADO for On-Line Analytical Processing (OLAP) – the data management techniques that are widely used in decision support systems and data warehousing. We will also discuss two ways of implementing OLAP with ADO and Delphi, such as using client-side OLAP and server-side one."