Introduction to ADO

ADO is used to access the database from the web.

You should have basic knowledge

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

• WWW, HTML and basic knowledge of the site to build
• ASP (Active Server Pages)
• SQL (Structured Query Language)

If you want to study these subjects first, please our home page to access these tutorials.

What is ADO?

• ADO is a Microsoft technology
• ADO means ActiveX Data Objects (A ctiveX D ata O bjects)
• ADO is a Microsoft Active-X components
• ADO is automatically installed with Microsoft IIS
• ADO to access data in a database is a programming interface

Access to the database from an ASP page

From the usual method inside an ASP page to access the database are:

1. Create a connection to the database ADO
2. Open Database Connectivity
3. Create ADO record set
4. You need to extract the data from the record set
5. Off the record set
6. Close connection