New or enhanced features in the SAS Data Providers include the following:
Note: This section describes the features of the SAS Data Providers that are new or enhanced since SAS 8.2.
Version 6 of the SAS/SHARE Server is no longer supported by the SAS/SHARE Data Provider. You can still connect to Version 7 or later SAS/SHARE servers.
The new SAS OLAP Data Provider supports access to multidimensional data on a SAS OLAP Server through the OLE DB for OLAP interfaces.
In addition to setting each property individually, the SAS IOM and SAS OLAP Data Providers now enable you to specify all the necessary properties in the Data Source.
The SAS Local Data Provider supports SAS data sets that were created under operating environments other than Windows. Data sets created for operating environments such as Solaris and HP-UX can be read directly by the SAS Local Data Provider.
The SAS IOM Data Provider now supports in-memory data caching by means of the new rowset property DBPROP_SAS_PAGESIZE, which controls how many rows the IOM server retrieves each time it processes a request. Retrieved rows are held in memory and are returned to the OLE DB consumer as needed. In-memory caching can significantly improve performance.
ADO recordsets also have a caching facility for improving performance. You can set the "CacheSize" property on the Recordset object to the number of rows that you want to retrieve on each request. To ensure the best performance, you set the "Maximum Open Rows" (DBPROP_MAXOPENROWS) property to a value that is at least twice the value of the "CacheSize" property.
Optimized accessors are supported as described by the OLE DB specification, and they can be used for application-specific performance tuning.
For the SAS IOM Data Provider, positioning improvements are available only when caching is enabled. If you have legacy applications that are dependent on the positioning model used in SAS Data Provider releases prior to SAS 9, you can disable caching and return to the previous model.
The SAS Data Providers now support all rows and columns that are supported in SAS. For OLE DB consumers, two interfaces have been added to SASExtensions.h:
(ADO consumers do not have access to these interfaces.)
Because longer names for formats and informats are supported, all SAS Data Providers can use SAS formats when reading data. The SAS IOM Data Provider can write data using SAS informats and apply user-written formats and informats.
All SAS Data Providers support both version-dependent and version-independent ProgIDs. This enables you to install different versions of the SAS Data Providers on the same operating environment and to write applications that use specific versions of the SAS Data Providers.
If you encounter a problem while using the SAS Data Providers, improved error messages give you more detailed information to help you diagnose and resolve problems more quickly.
The fixed-length column attribute is now set correctly by the SAS Data Providers. This attribute affects the type of column that ADO reports. Also, the range of column types has been expanded to include adVarChar and adVarWChar when the fixed-length column attribute is not set.
Single-user update access to a local installation of SAS is now provided by the SAS/SHARE Data Provider and users can perform SQL processing on local data sets. The SAS Local Data Provider no longer supports update access.