ADO Samples
Microsoft® SQL Server™ 2000 includes the following query applications to introduce you to using ADO:
| Sample | Description |
|---|---|
| ADO and Long Data Types (C++) | C++ language sample. Demonstrates how to use ADO to display long data types. |
| ADO and Long Data Types (Visual Basic) | Visual Basic sample. Demonstrates how to use ADO to display long data types. |
| ADO Connection and Error Handling | Visual Basic sample. Uses ADO to connect to an instance of SQL Server. |
| ADO and Long Data Types (Web) | Web sample. Demonstrates how to use ADO to display long data types. |
| ADO Web Application | Web sample. Demonstrates how to create a Web application using ADO. |
| ADO and FOR XML | XML sample. Retrieves result sets into streams using the Transact-SQL FOR XML clause. |
| ADO and Open XML | XML sample. Maps an XML schema to a relational schema using annotated schemas. |
| ADO and XPath Query | XML sample. Performs an XPath query. |
The ADO samples are not intended to be fully featured applications or demonstrations of the complete range of data access capabilities available through ADO. The samples are designed to cover some basic areas of ADO usage with SQL Server 2000, such as connecting to an instance of SQL Server, querying, editing, and updating a data source, handling multiple result sets, and enumerating provider errors.
To install the samples during SQL Server installation
- On the Setup Type page, select Custom.
- On the Select Components page, under Components, select Code Samples.
Samples are installed as a self-extracting file. To extract the samples, double-click Unzip_ado.exe, located at C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Ado.
Prerequisites
C and C++ samples require Microsoft Visual C++ version 6.0. Visual Basic samples require Microsoft Visual Basic version 6.0.