ADO Introduction
ADO is used to access databases from web pages.
Prerequisites
Before you continue, you need a basic understanding of the following:
- WWW, HTML, and a basic understanding of website construction
- ASP (Active Server Pages)
- SQL (Structured Query Language)
If you wish to first learn these items, please go to ourhomepageto visit these tutorials.
What is ADO?
- ADO is a Microsoft technology
- ADO stands for ActiveX Data Objects (ActiveX Data Objects）
- ADO is a Microsoft Active-X component
- ADO is automatically installed with Microsoft IIS
- ADO is a programming interface for accessing data in databases
Accessing a Database from an ASP Page
The usual way 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