2.2.2. Introduction to ADO

The basic knowledge you should have ¶

Before continuing, you need to have a basic understanding of the following knowledge:

• WWW, HTML and basic understanding of website construction

• ASP (dynamic server page)

• SQL (structured query language)

If you want to learn these projects first, please visit these tutorials on our home page.

What is ADO? ¶

• ADO is a Microsoft technology.

• ADO means ActiveX data object

• ADO is a Microsoft Active-X component

• ADO will be installed automatically with Microsoft IIS

• ADO is a programming interface to access data in a database.

Access the database from the ASP page ¶

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

1. Create an ADO connection to the database

2. Open a database connection

3. Create an ADO recordset

4. Extract the data you need from the recordset

5. Close the recordset

6. Close the connection