Introduction to ADO
ADO is used to access databases from web pages.
Prerequisites
Before you continue, you should have a basic understanding of the following:
WWW, HTML, and basic knowledge of website construction
ASP (Active Server Pages)
SQL (Structured Query Language)
If you wish to learn these topics first, please visit our homepage for these tutorials.
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's IIS
ADO is a programming interface for accessing data in a database
Accessing a Database from an ASP Page
The usual method to access a database from within an ASP page is:
Create an ADO connection to the database
Open the database connection
Create an ADO recordset
Extract the data you need from the recordset
Close the recordset
Close the connection