ADO Summary | Microsoft Windows Architecture for Developers Training Kit

SQL-DMO

Microsoft SQL Server Distributed Management Object (SQL-DMO) is a COM-based object model that allows developers to add SQL Server administrative features to an application. Although some administrative functions can be accomplished through the use of stored procedures or the Data Definition Languages, SQL-DMO provides an object model to make programming these functions easier.

SQL-DMO exposes database objects for manipulation by client applications. Tables, stored procedures, and server properties are presented through a COM interface.

Using SQL-DMO, applications can include the following capabilities:

Table maintenance
Access to server permission information
Databases listed per server
Scripts generated for a table

Note
SQL Server installs a reference to the Microsoft SQLOLE Object Library which is an ActiveX interface to SQL-DOM. While it is possible to obtain data from SQL Server tables using SQL-DMO, you should use RDO for this purpose.

Lesson Summary

DAO is the COM interface to Jet. It is a well-known interface that supports ISAM. However, DAO was not designed to work efficiently with ODBC, and it exhibits poor performance when used to connect to ODBC data types. To connect to a database using DAO, you must set a reference to DAO, declare DAO object variables , and open the connection. A Recordset object represents the records in a base table or the records that result from running a query. You can use Recordset objects to manipulate data in a database. When you use DAO objects, you manipulate data almost entirely using Recordset objects.

RDO is optimized for use with ODBC, and it provides capability with ISAM. Using RDO you can execute queries that return multiple result sets, limit the number of rows returned, and monitor all the messages generated by the remote data source without compromising the query. To connect using RDO, set a reference to RDO, then connect to a database using the Connection object. The Resultset object represents the rows returned from a query.

ADO is the data interface to OLE DB. It is designed to access databases of various types. Unlike DAO and RDO, ADO is an extensible programming model that uses independent data service providers to access specific databases.

SQL-DMO is a COM-based object model that allows developers to add SQL Server administrative features to an application. SQL-DMO exposes database objects for manipulation by client applications. Tables, stored procedures, and server properties are presented through a COM interface.