ADO Intro

ADO Introduction

---

ADO can be used to access databases from your web pages.

---

What you should already know

Before you continue you should have a basic understanding of the following:

• HTML
• ASP
• SQL

If you want to study these subjects first, go to our Home page

---

What is ADO?

• ADO is a Microsoft technology
• ADO stands for ActiveX Data Objects
• ADO is a Microsoft Active-X component
• ADO is automatically installed with Microsoft IIS
• ADO is a programming interface to access data in a database

---

Accessing a Database from an ASP Page

The common way to access a database from inside an ASP page is to:

1. Create an ADO connection to a database
2. Open the database connection
3. Create an ADO recordset
4. Open the recordset
5. Extract the data you need from the recordset
6. Close the recordset
7. Close the connection

Related topics

ADO Intro	ADO Connect	ADO Recordset	ADO Display	ADO Queries
ADO Sort	ADO Update	ADO Delete	ADO Demonstration	ADO Speed Up
ADO Command	ADO Connection	ADO Error	ADO Field	ADO Parameter
ADO Property	ADO Record	ADO Recordset	ADO Stream	ADO Data Types

---