README.TXT

**************************************************************** 
          MICROSOFT SQL SERVER WORKSTATION SYSTEM 6.5 
                OLE AUTOMATION SAMPLE PROGRAMS 
**************************************************************** 
This file describes the OLE automation sample programs included  
with Microsoft(R) SQL Server(TM) Workstation System 6.5. 
 
For additional information about SQL Server 6.5, DB-Library, and  
ODBC, see the "What's New in SQL Server 6.5," "Programming  
DB-Library for Visual Basic," and "Programming ODBC for SQL  
Server" sections of SQL Server Books Online, which containsthe  
most up-to-date information available. 
 
**************************************************************** 
OLE AUTOMATION SAMPLE APPLICATIONS 
 
The sample applications require the Microsoft(R) Visual Basic(R) 4.0  
Enterprise Edition. The following Visual Basic sample programs and  
Transact-SQL scripts are located in the C:\MSSQL\SAMPLES\OLEAUTO  
directory by default: 
 
GETNPV 
Demonstrates the use of an OLE Automation object to call an NPV  
function in Visual Basic from a trigger. Includes the following  
files: 
    CGETNPV.CLS 
    GETNPV.VBP 
    NPVMAIN.BAS 
    NPVTEST.SQL 
    NPVTRIG.SQL 
    TESTERR.SQL 
 
To run this application 
1.  Create the test table and trigger by running the NPVTEST.SQL  
    script. 
2.  Open the Visual Basic project, GETNPV.VBP. From the File Menu  
    choose Make EXE file or Make OLE DLL file to compile GETNPV.VBP. 
3.  Run the script, NPVTEST.SQL to insert sample data into the table.  
    The trigger then fires and calls the Visual Basic NPV function. 
4.  Run the script, TESTERR.SQL, to show an example of the VB  
    function raising a custom error message that can be retrieved by  
    calling sp_OAGetErrorInfo. 
 
LOOPBACK.DAO 
Demonstrates connecting back to a SQL Server via an OLE Automation 
object. The OLE Automation server retrieves a result set from a SQL  
Server table and returns it to the stored procedure that called it.  
In the Visual Basic project, if you make an OLE DLL file, the OA  
server that is created will run in the same process space as SQL  
Server. If you make an EXE file, the OA server will run as a separate  
process. Includes the following files: 
    CSQLDAO.CLS 
    DAOMAIN.BAS 
    LOOPDAO.SQL 
    SQLDAO.VBP 
 
LOOPBACK.RDO 
Demonstrates connecting back to a SQL Server via an OLE Automation 
object. The OLE Automation server retrieves a result set from a SQL  
Server table and returns it to the stored procedure that called it.  
In the Visual Basic project, if you make an OLE DLL file, the OA  
server that is created will run in the same process space as SQL  
Server. Ifyou make an EXE file, the OA server will run as a separate  
process. Includes the following files: 
    CSQLRDO.CLS 
    LOOPRDO.SQL 
    RDOMAIN.BAS 
    SQLRDO.VBP 
 
TRAVERSE 
Transact-SQL script that demonstrates how to use traversal syntax  
for object hierarchies. Uses the SQL-DMO administration objects.  
Includes the following file: 
    TRAVERSE.SQL