Export (0) Print
Expand All

OLE Automation Samples

SQL Server 2000

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
  1. On the Setup Type page, select Custom.

  2. 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.

See Also

Samples

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft