Using ADO with Microsoft SQL Server

The previous section on Microsoft Access covered the basics of performing the various types of queries in ADO. Because ADO is designed to present a common gateway to different data sources, there isn't a lot of difference in these basic operations whether your database is in Access or in SQL Server. Therefore, after a brief introduction to the few important differences that arise when using ADO with SQL Server, this section covers more advanced topics, including stored procedures, multiple recordsets, and disconnected recordsets.

The examples in this section use the SQL Server version of the Northwind sample database. This database is similar to the Access 2007 version of Northwind used previously, but there will be some differences in the names and data types of various fields.

0 0

Post a comment