1. Technology
Send to a Friend via Email

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 ...

Related Video
Using Meta Data for Search

©2014 About.com. All rights reserved.