Using the Active Data Object
The Active Data Object (ADO) is based on OLE DB, a C++ based applications programming interface (API). OLE DB refers to Microsoft's database connectivity approach based on object linking and embedding. Because the technology is based on C++, its API is object-oriented. ADO is similar to Microsoft's Data Access Object (DAO) and Remote Data Object (RDO). However, Microsoft designed ADO specifically with Internet-based applications in mind.
ADO enables you to add database connectivity to your ASP applications. Four main types of ADO objects enable you to communicate with and handle data from a database:
Connection— An ADO Connection object enables you to set up an open pipe into a system data source. When the pipe is ...