ADO Introduction

ADO is used to access databases from web pages.

Basic Knowledge You Should Have

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

  • WWW, HTML, and a basic understanding of website construction
  • ASP (Dynamic Server Page)
  • SQL (Structured Query Language)

If you want to learn these projects first, please visit our Home Page Access these tutorials.

What is ADO?

  • ADO is a Microsoft technology
  • ADO means ActiveX Data Object (AActiveX DData OObjects)
  • ADO is a Microsoft ActiveX component
  • ADO is automatically installed with Microsoft's IIS
  • ADO is a programming interface for accessing data in a database

Access Database from ASP Page

The usual method to access a database from within an ASP page is:

  1. Create an ADO connection to the database
  2. Open Database Connection
  3. Create an ADO Recordset
  4. Extract the data you need from the Recordset
  5. Close Recordset
  6. Close Connection