ADO Introduction

ADO acts as a bridge between the front end controls and the back end database.
ADO can be used to access databases from your web pages.

What you should already know

Should have a basic understanding of the following Languages : (You can Learn From our Repository)

• HTML and the basics of building Web pages
• Active Server Pages (ASP)
• Structured Query Language (SQL)

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