ADO and SQL Server

Microsoft® SQL Server™ data sources are ideally suited for access through ADO. Because SQL Server is fully OLE DB-compliant, you can use ADO to develop client applications, service providers, Web applications, and server business objects that access SQL Server data.

There are a number of considerations to take into account when programming ADO applications for SQL Server:

• OLE DB provider
• Development environment

Other considerations include:

• Microsoft’s Remote Data Services (RDS).

  RDS is a Web-based technology that uses Microsoft’s Internet Information Services and special Microsoft ActiveX® controls to bind data from an ODBC SQL data source to data controls on a Web page. ADO is completely integrated with RDS technology. For more information about RDS, see the Microsoft MSDN™ Library, Microsoft Visual Studio® version 6.0 edition.

• Required data access functionality (cursor, transaction type, how to deal with stored procedures, and so on).

For more information about these issues, see ADO Programming Considerations.