YouTip

# Introduction to ADO * * * ADO is used to access databases from web pages. * * * ## Prerequisites Before continuing, you should have a basic understanding of the following: * WWW, HTML, and basic website development * ASP (Active Server Pages) * SQL (Structured Query Language) If you'd like to learn these topics first, please visit our tutorials on the (http://w3cschool.cc/ "W3CSchool Online Tutorials"). * * * ## What is ADO? * ADO is a Microsoft technology * ADO stands for _A_ctiveX _D_ata _O_bjects * ADO is a Microsoft Active-X component * ADO is automatically installed with Microsoft's IIS * ADO is a programming interface for accessing data in databases * * * ## Accessing Databases from ASP Pages The typical method for accessing a database from within an ASP page is: 1. Create an ADO connection to the database 2. Open the database connection 3. Create an ADO recordset 4. Extract the required data from the recordset 5. Close the recordset 6. Close the connection