About the SAS Providers for OLE DB: Cookbook

How the Cookbook Can Help You Write Applications

The SAS Providers for OLE DB: Cookbook provides programming recipes that are designed to jump-start your development efforts in these ways:
  • by providing ready-to-use sample code
  • by encouraging best practices
  • by answering frequently asked questions
You can use the recipes directly or modify them to fit your needs.
Sample code for ADO is written in Visual Basic 6. Sample code for OLE DB is written in Visual C++.
Note: Unless otherwise noted, all of the recipes can be implemented by using either ADO or OLE DB. This statement is true even if the OLE DB method is not discussed in the recipe.

What You Should Know in Order to Use This Cookbook

The cookbook assumes that the following statements are true:
  • You know how to program by using ADO.
  • You are familiar with the OLE DB architecture and specifications.
  • You know how to program in an object-oriented or object-based language such as Visual C++ and Visual Basic.
  • You are familiar with the information in resources such as these:
    • Microsoft Corporation. 1998. OLE DB Programmer's Reference and Data Access SDK. Redmond, WA: Microsoft Press.
    • The Microsoft Developers Network (MSDN) Library.
    • Sussman, David, and Homer, Alex. 1999. ADO 2.1 Programmer's Reference. Chicago: Wrox Press Inc.
    • Wood, Chuck. 1999. OLE DB and ODBC Developer's Guide. Foster City, CA: IDG Books Worldwide.
  • Either you know how to start up the SAS server that you want to access or the server has been started for you.