Contents Windows Clients

 Core Functions
* Initializing a
* Data Source Component
* Opening an
* Existing Data Set
* Data Set Management
* via ITableDefinition
* Column Mapping
* and Binding
* Bookmarks
* and Random Access
* Schema Rowsets
* Command Processing
* Format Processing
 Appendices
* Installation Notes
* Implemented Interfaces
* Performance Considerations
* OLE DB Customizations
* Properties
* Properties by Provider
* Properties by Group
* Alphabetical List
* Error Objects
* Using VBScript
* Programming With C++ 		       

Using the IOM Data Provider

The SAS(R) IOM Data Provider is an OLE DB data provider that delivers access to SAS data sets found in SAS Integrated Object Model (IOM) servers.

An OLE DB data provider is a set of software components that expose a data source to applications in conformance with Microsoft's OLE DB specification. This specification, built on the COM model, provides applications with standard interfaces to use when accessing data from any type of information source. OLE DB providers may expose many COM interfaces. These interfaces are grouped into seven object types: DataSource, Session, Command, Rowset, Index, ErrorObject and Transaction. The IOM provider currently supports all but the Index and Transaction objects.

OLE DB providers, including the IOM provider, may be used by applications written in Visual C++, VBScript, Java, JScript or Visual Basic. Applications may be written to the higher level ActiveX Data Objects (ADO) interface using any of these languages, or directly to the OLE DB specification using Visual C++. This document pertains primarily to Visual C++ applications.

This document also assumes a working knowledge of the OLE DB architecture and specification. For more information about OLE DB, see the following information sources:

  • Microsoft Corporation. (1998), OLE DB Programmer's Reference and Data Access SDK. Redmond Washington: Microsoft Press
  • Sussman, David. (1999) ADO 2.1 Programmer's Reference , Chicago Wrox Press Inc.
  • Wood, Chuck. OLE DB and ODBC Developer's Guide (1999) Foster City, CA: IDG Books Worldwide

Feature set

Through the OLE DB interfaces, the IOM provider adds to consumer programs a range of functionality which includes:

  • Both read-only and update access to SAS data files on all platforms that IOM supports
  • Either exclusive access (member level lock) or multiple user access (record level lock) to SAS data files, selectable on a per- rowset open basis
  • Both immediate and delayed update modes through the IRowsetChange and IRowsetUpdate interfaces
  • Creation of new data sets through the ITableDefinition interface
  • Random access services via the IRowsetLocate interface
  • SQL query and command support through the OLE DB Command object
  • Basic OLE DB schema rowsets, which enable clients to discover metadata about the data source they are connected to
  • Integrated SAS formatting services. The core set of SAS formats that have been included can be used when reading or modifying data.
To get started quickly with the SAS IOM Data Provider, you can refer to the SAS® 9 Data Providers: ADO/OLE DB Cookbook. This cookbook, which applies to all three SAS OLE DB data providers, contains ADO examples written in Microsoft Visual Basic as well as OLE DB examples written in Microsoft Visual C++. You can either apply the examples directly or use them with minimal modification.