ADO TutorialLesson 61Free preview

ADO Intro

This lesson is part of ASP · All levels

Summary

ADO (ActiveX Data Objects) is a collection of COM objects used by scripts such as Classic ASP to access and manage data from a variety of sources. The main models are Connection for connections, Command for parametric queries, and Recordset for line output. With ADO, the same code pattern can be used for SQL Server, Access, or other OLE DB providers.

Key points

ADO works on the OLE DB provider for various data sources.
The main objects: Connection, Command, and Recordset.
The recordset represents the result of a query in a set of rows and columns.
ADO can be used from VBScript, VB, and other COM languages.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.