• Contents
  • About
  • Title Page
  • What's New in the SAS 9.2 Providers for OLE DB
  • Introduction
    • Introduction to the SAS Providers for OLE DB
      • About the SAS Providers for OLE DB: Cookbook
      • About the SAS Providers for OLE DB
      • Data Sources and File Types Supported by the SAS Providers
      • Features Supported by the SAS Providers
      • Tips for 64-bit Programming
    • System Requirements and Installation
      • System Requirements
      • SAS Provider for OLE DB Installation
      • Accessibility Features of the SAS Providers for OLE DB
  • Getting Started
    • Finding Recipes
      • Using This Recipe Guide
      • Local Provider Recipes
      • IOM Provider Recipes
      • SAS/SHARE Provider Recipes
      • Base SAS Provider Recipes
      • OLAP Provider Recipes
    • Learning about SAS Connections
      • What You Need to Know about SAS Connections
      • How to Identify the SAS Providers
      • ADO Connection Properties for the SAS Providers
      • Three Ways to Open an ADO Connection Object
      • Using the Data Source Property to Specify All Connection-Related Properties
  • Connection Recipes
    • Opening an ADO Connection Object
      • Basic Connection Recipes
      • Connecting to Local Data
      • Connecting to Local Data (Single-User Server)
      • Connecting to a Remote SAS/SHARE Server
      • Connecting to a Remote SAS Workspace Server
      • Connecting to a Remote SAS Workspace Server Using SAS Objects
      • Connecting to a Remote SAS OLAP Server
    • Managing Connections
      • Supplemental Connection Recipes
      • Prompting Users for Connection Information by Displaying the Data Link Properties Dialog Box
      • Using a Microsoft Data Link (.udl) File to Provide Persistent Connection Information
      • Controlling Data Access Permissions with a Connection
      • Managing File Formats with the Local Provider
      • Reusing an Existing IOM Workspace
      • Connecting to a Specific SAS/SHARE Server Version
  • Data Management Recipes
    • Accessing Specific or Protected Data
      • Data Access Recipes
      • Identifying a Data Set and Returning Results
      • Specifying a Libref to Use with the IOM Provider
      • Opening a Password-Protected Data Set
      • Accessing Third-Party Data through SAS/ACCESS Engines
      • Displaying Metadata That Is Specific to SAS Data Sets
      • Reading SAS OLAP Cubes
    • Creating, Subsetting, and Deleting Data Sets
      • Creating, Subsetting, and Deleting Data Sets Recipes
      • Creating and Deleting Data Sets
      • Subsetting Data Sets for Read-Only Sequential Access
      • Subsetting Data Sets for Random and Update Access
    • Specifying How to Display Data
      • Displaying Data Recipes
      • Using SAS Formats When You Read Data
      • Using SAS Informats When You Write Data
      • Reading User-Defined SAS Formats and Informats
      • Padding Character Data with Blanks
    • Managing Missing Values
      • Missing Value Recipes
      • Reading Missing Values from a Data Set
      • Reading Special Numeric Missing Values from a Data Set
      • Writing Missing Values to a Data Set
    • Managing Updates
      • Updating and Locking Recipes
      • Updating Recordsets
      • Implementing a Locking Strategy
  • Tips and Best Practices
    • Tuning the Providers for Performance
      • Properties That Affect Performance
      • How the "CacheSize" Property Affects Performance
      • How the "Maximum Open Rows" Property Affects Performance
      • How the SAS Page Size Property Affects Performance
      • How the SAS Data Set Options Property Affects Performance
    • Writing Code That Returns Provider Information
      • How to Generate a List of Supported ADO Properties
      • How to Retrieve Version Information for a Provider
  • Troubleshooting
    • Handling Error Objects
      • Using ADO to Handle Errors
      • Using OLE DB to Handle Errors
    • Known Issues
      • Known Issues for All Providers
      • Known Issues for the IOM Provider
      • Known Issues for the Local Provider
      • Known Issues for the SAS/SHARE Provider
  • Appendixes
    • ADO: Supported Cursor and Lock Type Combinations
      • Working with Cursor and Lock Type Combinations
      • Server-Side Cursor Combinations
      • Client-Side Cursor Combinations
    • ADO: Supported Methods and Properties
    • OLE DB Properties
      • OLE DB Properties: Introduction
      • OLE DB Properties: Descriptions
      • OLE DB Properties: Sorted by ADO Name
      • OLE DB Properties: Sorted by Data Provider
      • OLE DB Properties: Sorted by Group
    • OLE DB Interfaces
      • About OLE DB Interfaces
      • Standard OLE DB Interfaces
      • OLE DB for OLAP Interfaces
      • Custom Interfaces
      • Data Set Management Using the ITableDefinition Interface
    • Schema Rowsets
      • About Schema Rowsets
      • CATALOGS Schema Rowset
      • COLUMNS Schema Rowset
      • CUBES Schema Rowset
      • DIMENSIONS Schema Rowset
      • FUNCTIONS Schema Rowset
      • HIERARCHIES Schema Rowset
      • LEVELS Schema Rowset
      • MEASURES Schema Rowset
      • MEMBERS Schema Rowset
      • PROPERTIES Schema Rowset
      • PROVIDER_TYPES Schema Rowset
      • SETS Schema Rowset
      • TABLES Schema Rowset
    • OLE DB: Format Processing
      • About Format and Informat Processing with OLE DB
      • How to Specify Format Processing When Binding Columns
      • Using Formats for Input Operations
      • Overriding Formats for Input Operations
      • Processing Informats for Output Operations
      • How to Simultaneously Bind Columns to Formats and Informats
    • OLE DB: Column Mapping and Binding
      • About the Mapping and Binding Process
      • Returning Column Metadata
      • Mapping to SAS Constructs
      • Binding to Rowset Columns
    • Customized User Help for the Data Link Properties Dialog Box
      • Data Link Properties Dialog Box (Connection Tab)
      • Data Link Properties Dialog Box (Advanced Tab)
  • Glossary


ProductRelease
Base SAS9.2
SAS Integration Technologies9.2
SAS Providers for OLE DB9.2
SAS/SHARE9.2
Type
Usage and Reference
Copyright Date
March 2008
Last Updated
15Apr2008