SQL Server ADO Programmer's Reference

ADO and SQL Server

ADO and SQL Server

SQL Server ADO Programmer's Reference

Microsoft® ActiveX® Data Objects (ADO) is a Win32 API used by applications to manipulate data in a database server through an OLE DB provider.

The SQL Server ADO Programmer's Reference does not document all of the ADO features. Those features that have provider-specific properties, parameters, or behaviors when used with the Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are discussed.

SQLOLEDB allows ADO to access Microsoft SQL Server, and supports these provider-specific features:

  • Command dynamic properties

  • Connection dynamic properties

  • Connection parameters

  • Recordset dynamic properties

These features use ADO 2.6.

For more information about ADO, see the MSDN Library at the Microsoft Web site.