Home arrow Delphi-Kylix arrow Using Delphi with ADO
DELPHI-KYLIX

Using Delphi with ADO


This article, the first of three parts, shows you how to access and change database content using Delphi and ADO. Accessing data both with and without data aware components is covered.

Author Info:
By: Jacques Noah
Rating: 4 stars4 stars4 stars4 stars4 stars / 18
October 02, 2006
TABLE OF CONTENTS:
  1. · Using Delphi with ADO
  2. · Accessing Database Content
  3. · Practical Example with Data Aware Components
  4. · Practical Example Without Data Aware Components

print this article
SEARCH DEVARTICLES

Using Delphi with ADO
(Page 1 of 4 )


Download the database and example program here.

ActiveX Data Objects, or ADO as it is known, is classed as an application-level interface by Microsoft. In short, it is a system designed for database application programmers. It is mostly used on Windows-based systems for data navigation and manipulation of datasets. 

Microsoft Data Access Components (MDAC) is an umbrella for Microsoft database technologies, which include ADO. Most Windows-based systems will have MDAC  installed. For example, if you have Internet Explorer, you'll definitely have MDAC installed. So, when you deploy your database applications, you do not for the most part have to worry about your users having this technology on their systems, as over ninety percent of all computer owners own a Microsoft-operated system. Having said that, it is still important to err on the side of caution and include code that will check whether MDAC is installed. It is also worthwhile to check for the latest MDAC release on the Microsoft website now and then.

Delphi ships with a whole host of other database technologies, such as BDE and Interbase. The choice of database you use will largely depend on what you are using it for. For example if you are running a very popular website, then you cannot use a Microsoft Access database to store your information in, because it is not designed to store large amounts of information. A database server such as MSSQL or MySQL would be more suitable. Similarly, if you create a small application that handles address book information, it would be overkill to use a database server such as MySQL or MSSQL; a smaller database such as MS Access would be suitable.


blog comments powered by Disqus
DELPHI-KYLIX ARTICLES

- Loading an XML Document into the DOM
- Delphi Wrapper Classes and XML
- Delphi and the DOM
- Delphi and XML
- Internet Access: Client Service
- Finishing the Client for an Internet Access ...
- The Client for an Internet Access Control Ap...
- User Management for an Internet Access Contr...
- Important Procedures for an Internet Access ...
- Server Code for an Internet Access Control A...
- Constructing the Interface for an Internet A...
- Building a Server Application for an Interne...
- Building an Internet Access Control Applicat...
- Client Dataset: Working with Data Packets an...
- Using the Client Dataset in an N-Tiered Appl...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials