Object Linking and Embedding (OLE) samples

Directories. Visual Basic: sqllib\samples\ole\msvb; Visual C++: sqllib\samples\ole\msvc.

Table 1. Object Linking and Embedding (OLE) sample programs
Sample program name Program description
sales Demonstrates rollup queries on a Microsoft Excel sales spreadsheet (implemented in Visual Basic).
names Queries a Lotus Notes address book (implemented in Visual Basic).
inbox Queries Microsoft Exchange inbox e-mail messages through OLE/Messaging (implemented in Visual Basic).
invoice An OLE automation user-defined function that sends Microsoft Word invoice documents as e-mail attachments (implemented in Visual Basic).
bcounter An OLE automation user-defined function demonstrating a scratchpad using instance variables (implemented in Visual Basic).
ccount A counter OLE automation user-defined function (implemented in Visual C++).
salsrv An OLE automation stored procedure that calculates the median salary of the STAFF table of the sample database (implemented in Visual Basic).
salcltvc A Visual C++ CLI sample that calls the Visual Basic stored procedure, salsrv.
salcltvb A Visual Basic CLI sample that calls the Visual Basic stored procedure, salsrv.
salsvado An OLE automation stored procedure, implemented in 32-bit Visual Basic and ADO, that demonstrates output parameters by calculating the median salary in newly-created table, STAFF2, and demonstrates result sets by retrieving salaries from the table.
salclado A Visual Basic client that calls the Visual Basic stored procedure, salsvado.
testcli An OLE automation embedded SQL client application that calls the stored procedure, tstsrv (implemented in Visual C++).
tstsrv An OLE automation stored procedure demonstrating the passing of various types between client and stored procedure (implemented in Visual C++).