Samples
OLE Automation Samples
The following samples illustrate Microsoft® SQL Server™ 2000 OLE Automation application development.
| Sample | Description |
|---|---|
| Getnpv OLE Automation Sample | Microsoft Visual Basic® sample. Returns a net present value from a query. |
| Loopback (DAO) OLE Automation Sample | Visual Basic sample. Retrieves contents of the input table name provided to the DAO table and returns a tabular array equivalent to the result set returned from SQL Server. |
| Loopback (RDO) OLE Automation Sample | Visual Basic sample. Uses RDO to call SQL Server and get the contents of the authors table, and returns a tabular array equivalent to the result set returned from SQL Server. |
| Traverse OLE Automation Sample | Transact-SQL sample. Demonstrates how to use traversal syntax for object hierarchies. |
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_oleauto.exe, located at C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Oleauto.
Prerequisites
Visual Basic samples require Microsoft Visual Basic version 6.0.