OLE DB Properties: Descriptions

DBPROP_APPENDONLY

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): Append-Only Rowset
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_AUTH_PASSWORD

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): Password
Notes:
Use this property to identify the password to use when connecting to a server. Use this property in conjunction with the DBPROP_AUTH_USERID property.
Local Provider: This property is ignored by the local provider.
IOM Provider: When connecting to a remote SAS Workspace Server, set this property to the user's log-in password. However, you do not need to set this property in these two circumstances:
  • You are connecting to an existing workspace via the DBPROP_SAS_INIT_WORKSPACE property.
  • You are instantiating a new local server by setting DBPROP_INIT_DATASOURCE to _LOCAL_.
SAS/SHARE Provider: Set this property to the user's log-in password when you connect to a SAS/SHARE server that requires user authentication. Consult your SAS/SHARE server administrator if you are not sure about your server's authentication requirements.
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_AUTH_USERID

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): User ID
Notes:
When connecting to a server, use this property to identify the user's log-in ID. Use this property in conjunction with the DBPROP_AUTH_PASSWORD property.
Local Provider: This property is ignored by the local provider.
IOM Provider: When connecting to a remote SAS Workspace Server, set this property to the user's log-in ID. However, you do not need to set this property in these two circumstances:
  • You are connecting to an existing workspace via the DBPROP_SAS_INIT_WORKSPACE property.
  • You are instantiating a new local server by setting DBPROP_INIT_DATASOURCE to _LOCAL_.
SAS/SHARE Provider: Set this property to the user's log-in ID when connecting to a SAS/SHARE server that requires user authentication. Consult your SAS/SHARE server administrator if you are not sure about your server's authentication requirements.
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_BOOKMARKS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): Use Bookmarks
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_BOOKMARKSKIPPED

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Skip Deleted Bookmarks
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_BOOKMARKTYPE

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): Bookmark Type
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_BYREFACCESSORS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Pass By Ref Accessors
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_CANFETCHBACKWARDS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): Fetch Backwards
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_CANHOLDROWS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): Hold Rows
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_CANSCROLLBACKWARDS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): Scroll Backwards
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_CLIENTCURSOR

Supported in: SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): ClientCursor
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK. This property supports client-side cursors in ADO applications.

DBPROP_CURRENTCATALOG

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source
Property Set: DBPROPSET_DATASOURCE
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): Current Catalog
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_DATASOURCEREADONLY

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Read-Only Data Source
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_DATASOURCE_TYPE

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): Data Source Type
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_DBMSNAME

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_BSTR
Description (ADO property name): DBMS Name
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_DBMSVER

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_BSTR
Description (ADO property name): DBMS Version
Notes:
Local Provider: Identifies the release version of the provider. Returns the same value as DBPROP_PROVIDERVER.
IOM and SAS/SHARE Providers: Identifies the release version of the connected server.
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IAccessor

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): IAccessor
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IColumnsInfo

Supported in: IOM Provider, OLAP Provider , Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): IColumnsInfo
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IConvertType

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): IConvertType
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_INIT_ASYNCH

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_DBINIT
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Asynchronous Processing
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_INIT_DATASOURCE

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): Data Source
Notes:
Use this property to identify the server or physical disk location that you want to connect to.
Local Provider: Set this property to the directory location that contains your data. The directory specification can be a local drive, a mounted drive, or the fully qualified path to a network drive. You can also set this property to "_LOCAL_" if you want to specify a fully qualified file path when opening a rowset.
IOM Provider: Set this property to "_LOCAL_" when you want a SAS Workspace Server connection. When creating a remote SAS Workspace Server connection, you can set this property to any string that you want to associate with the connection.
SAS/SHARE Provider: Set this property to the name of the SAS/SHARE server to which you want to connect. Consult your SAS/SHARE server administrator if you do not know the server name. If you are using DBPROP_SAS_INIT_LOCALSERVER to start the server, then you must use the same Server ID passed in via the DBPROP_SAS_INIT_SASPARAMETERS property.
OLAP Provider: Set this property to the network DNS name of the OLAP server or the IP address of the OLAP server. When connecting to a remote OLAP server, use this property in conjunction with DBPROP_SAS_INIT_SERVICENAME, DBPROP_SAS_INIT_PROTOCOL, and DBPROP_SAS_INIT_PORT.
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_INIT_HWND

Supported in: IOM Provider, OLAP Provider, Local Provider
Property Group: Initialization
Property Set: DBPROPSET_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): Window Handle
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_INIT_LCID

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): Locale Identifier
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_INIT_LOCATION

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): Location
Notes:
Local Provider: This property is ignored by the Local Provider.
IOM Provider: This property is ignored by the IOM Provider.
SAS/SHARE Provider: When connecting to a server that is running on a different node than the client, set this property to the DNS name of the node that is hosting the server.
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_INIT_MODE

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): Mode
Notes:
Use this property to specify access permissions to the connected data source.
All five data providers honor the following bitmasks:
  • DB_MODE_READ
  • DB_MODE_READWRITE
  • DB_MODE_SHARE_DENY_NONE
Other bitmasks are ignored and the mode is degraded to (DB_MODE_READ | DB_MODE_SHARE_DENY_NONE).
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_INIT_PROMPT

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_I2
Description (ADO property name): Prompt
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_INIT_PROVIDERSTRING

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): Extended Properties
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IRowset

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): IRowset
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IRowsetChange

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): IRowsetChange
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IRowsetIdentity

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): IRowsetIdentity
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IRowsetInfo

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): IRowsetInfo
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IRowsetLocate

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): IRowsetLocate
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IRowsetUpdate

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): IRowsetUpdate
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IRowsetView

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): IRowsetView
Notes:
Experimental.

DBPROP_ISupportErrorInfo

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): ISupportErrorInfo
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_IViewFilter

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_VIEW
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): IViewFilter
Notes:
Experimental.

DBPROP_IViewRowset

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_VIEW
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): IViewRowset
Notes:
Experimental.

DBPROP_IViewSort

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_VIEW
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): IViewSort
Notes:
Experimental.

DBPROP_LITERALBOOKMARKS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Literal Bookmarks
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_LITERALIDENTITY

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Literal Row Identity
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_LOCKMODE

Supported in: IOM Provider, OLAP Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): Lock Mode
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_MAXOPENROWS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): Maximum Open Rows
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_MAXORSINFILTER

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_VIEW
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Maximum OR Conditions
Notes:
Experimental.

DBPROP_MAXPENDINGROWS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Maximum Pending Rows
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_MAXROWS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Maximum Rows
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_MAXSORTCOLUMNS

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_VIEW
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Maximum Sort Columns
Notes:
Experimental.

DBPROP_MSMD_MDX_CALCMEMB_EXTENSIONS

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_MDX_EXTENSIONS
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): MDX Calculated Members Extensions

DBPROP_ORDEREDBOOKMARKS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): Bookmarks Ordered
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_OTHERINSERT

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Others' Inserts Visible
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_OTHERUPDATEDELETE

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Others' Changes Visible
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_OWNINSERT

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Own Inserts Visible
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_OWNUPDATEDELETE

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Own Changes Visible
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_PROVIDERVER

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_BSTR
Description (ADO property name): Provider Version
Notes:
Use this property to identify the release version of the provider. The major release, minor release, revision number, and build number are encoded in the returned value.
Local Provider: Returns the same value as DBPROP_DBMSVER.
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_REMOVEDELETED

Supported in: Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Remove Deleted Rows
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_SAS_ALTERPASSWORD

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Alter Password
Notes:
Use this property to access read-protected, write-protected, or alter-protected SAS files.
For more information about the SAS data set password facility, see "File Protection" in SAS Language Reference: Concepts.

DBPROP_SAS_BLANKPADDING

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): SAS Preserve Trailing Blanks
Notes:
If the value of DBPROP_SAS_BLANKPADDING is VARIANT_TRUE when character data is read, then trailing blanks are preserved. Otherwise, trailing blanks are trimmed.

DBPROP_SAS_DATASET_ENCODING

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_UI4
Description (ADO property name): "SAS Data Set Encoding"
Notes:
Use this property to retrieve the data set encoding value from SAS data sets.

DBPROP_SAS_DATASET_LABEL

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): "SAS Data Set Label"
Notes:
Use this property to set and retrieve the data set label value from SAS data sets.

DBPROP_SAS_DATASET_TYPE

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): "SAS Data Set Type"
Notes:
Use this property to set and retrieve the data set type value from SAS data sets.

DBPROP_SAS_DATASET_WINDOWS_CODEPAGE

Supported in: Local Provider, SAS/SHARE Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: No
Column: False
Type: VT_UI4
Description (ADO property name): "SAS Data Set Windows Code Page"
Notes:
Use this property to retrieve the Windows Code Page ID that is determined from the encoding value of the SAS data set. The default value of this property is 1252, which is the Western Latin 1 encoding.

DBPROP_SAS_DATASETOPTS

Supported in: IOM Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): "SAS Data Set Options"
Notes:
Use this property to specify SAS data set options when directly opening a table. For more information about SAS data set options, see "SAS Data Set Options" in SAS Language Reference: Dictionary.

DBPROP_SAS_DEFAULTFILEFORMAT

Supported in: Local Provider
Property Group: Data Source Information
Property Set: DBPROPSET_SAS_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Default File Format
Notes:
Use this property to define the default value for DBPROP_SAS_INITFILEFORMAT. The value can change from one release of the provider to the next. In general, the default file format that is identified by this property corresponds to the data set format of the latest major SAS release.

DBPROP_SAS_ENGINE

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Library Engine
Notes:
Use this property to specify the name of the engine to use when this rowset is opened.
The available engines depend on the host system, the version of SAS, and the site installation. This property is comparable to the engine name option in the SAS LIBNAME statement.
When this property is set, DBPROP_SAS_PATH must also be set. If DBPROP_SAS_ENGINE is not set and DBPROP_SAS_PATH is set, then the default engine is used.

DBPROP_SAS_FMTERR

Supported in: Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): SAS Format Error
Note:
Use this property to control how the provider handles unknown format and informat names. When the property value is VARIANT_TRUE, the provider generates an error during row I/O operations if the associated format or informat is not found. When the property value is VARIANT_FALSE and the associated format or informat is not found, then the provider uses BESTw.d for numeric columns and $CHARw. for character columns.

DBPROP_SAS_FORMATS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Formats
Notes:
Use this property to format columns of data. You can use one of the following string values:
  • "_ALL_" , which indicates that all variables should be returned as formatted values.
  • "+_ALL_" , which indicates that all variables should be returned as both formatted and unformatted values.
  • a comma-separated list with items of the following form:
    [+]COLUMN[=FORMAT[w].[d]]
    • The optional plus (+) modifier indicates that the variable should be returned as both formatted and unformatted values.
    • COLUMN is the name of the variable that you want to format.
    • FORMATw.d is the SAS format that you want to apply. If this value is not given, then the default format is used.
Use this property only for ADO consumers. OLE DB consumers should not use this property to format data.

DBPROP_SAS_GET_MISSING_VALUES

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): SAS Get Missing Values Grid
Notes:
Use this property to control whether a grid that represents special numeric missing values data is returned or standard data is returned to the user. This property can have the following values:
  • True, to indicate that the SAS missing values grid is requested. In order to identify the special numeric missing values, the returned data set is the opposite of the standard data values. Numeric fields that have a value such as 15 are instead returned as Null. Fields that have a missing value return a number that identifies the SAS numeric missing value indicator. All character fields are returned with a length of zero.
  • False, to indicate that standard data set values are requested. False is the default setting.
For more information about this property, see Reading Special Numeric Missing Values from a Data Set.

DBPROP_SAS_INFORMATS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Informats
Notes:
Use this property to apply informats to columns of data. You can use one of the following string values:
  • "_ALL_" , which indicates that all variables should be output using informatted values.
  • a comma-separated list with items of the form: 
    COLUMN[=INFORMAT[w].[d]]
    • COLUMN is the name of the variable that you write with an informat.
    • INFORMATw.d is the SAS informat that you want to apply. If this informat is not given, then the default informat is used.
Use this property only for ADO consumers. OLE DB consumers should not use this property to informat data.

DBPROP_SAS_INIT_CELLCACHESIZE

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): SAS Cell Cache Size
Notes:
This property defines the maximum number of cells that will be cached by the OLAP Provider at any one time. Cached cells are used only to handle requests for single cells (that is, calls to IMDDataset::GetCellData where ulStartCell and ulEndCell are equal). The actual number of cells cached in each MDDataset is based on the number of tuples along the column's axis. Usually, the number of tuples is equivalent to the number of cells in one row. The following formula can be used to determine the number of cached cells:
floor( SAS Cell Cache Size / Number of cells per row ) * Number of cells per row
For example, assume that you have an MDDataset with five cells in a row. A SAS Cell Cache Size of 12 results in floor( 12 / 5 ) * 5 = floor( 2.4 ) * 5 = 2 * 5 = 10 cells actually cached. For this MDDataset, all values for SAS Cell Cache Size between 10 and 14 (inclusive) will yield 10 cached cells.
This property can have the following values:
  • -1 indicates that the entire MDDataset will be cached in memory.
  • 0 indicates that caching will be disabled.
  • >0 indicates the maximum number of cells that will be cached.

DBPROP_SAS_INIT_FILEFORMAT

Supported in: Local Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS File Format
Notes:
Use this property to define the SAS file format associated with the data source. The Local Provider supports the following file formats:
  • Version 6 data sets
  • Versions 7, 8, and 9 data sets
  • Version 5 transport files
This property accepts a string value that indicates which file format to associate with the directory that is given the DBPROP_INIT_DATASOURCE value. Valid strings for DBPROP_SAS_INIT_FILEFORMAT are as follows:
  • "V9" for Version 9, Version 8, or Version 7 data sets
  • "V8" for Version 8 or Version 7 data sets
  • "V7" for Version 7 or Version 8 data sets
  • "V6" for Version 6 data sets
  • "XPT" for Version 5 transport files
"V7" and "V8" specify the equivalent file formats and can be used interchangeably.
If no value is set for this property, then the provider examines the data source directory to determine which file format to use. If a decision cannot be made based on the contents of the data source directory, then the provider uses the DBPROP_SAS_DEFAULTFILEFORMAT value as the default for DBPROP_SAS_INIT_FILEFORMAT.
Note: When you specify a value of "V8", the Local Provider does not properly convert numeric variables for SAS data sets created on platforms other than Windows. In this case, the Local Provider returns incorrect data for the numeric variable (although it does not return an error). To ensure that numeric variables are converted properly for SAS data sets on platforms other than Windows, use the default file format or "V9".

DBPROP_SAS_INIT_LOCALSERVER

Supported in: SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): SAS Local Server
Note:
Use this property to determine whether the SAS/SHARE Provider will start a local server. The value for this property can be 0 or 1. Zero is the default value and indicates that the provider should not start a server. One indicates that the SAS/SHARE provider should start a local server.

DBPROP_SAS_INIT_LOGICALNAME

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Logical Name
Note:
This property is obsolete and is provided only for backward compatibility.

DBPROP_SAS_INIT_MACHINEDNSNAME

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Machine DNS Name
Notes:
Use this property to specify the network DNS name of the server or the IP address of the server.
When connecting to a remote SAS Workspace Server, use this property in conjunction with DBPROP_SAS_INIT_SERVICENAME, DBPROP_SAS_INIT_PROTOCOL, and DBPROP_SAS_INIT_PORT.

DBPROP_SAS_INIT_PORT

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): SAS Port
Notes:
Use this property to identify the TCP/IP port number to use on the machine that is hosting the SAS Workspace Server.
When connecting to a remote SAS Workspace Server, use this property in conjunction with DBPROP_SAS_INIT_MACHINEDNSNAME and DBPROP_SAS_INIT_PROTOCOL. This property is functionally equivalent to DBPROP_SAS_ INIT_ SERVICENAME.

DBPROP_SAS_INIT_PROTOCOL

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): SAS Protocol
Notes:
Use this property to indicate how to communicate with the SAS server. Its value is either ProtocolCom, ProtocolCorba, or ProtocolBridge.
When connecting to a remote SAS Workspace Server, use this property in conjunction with DBPROP_SAS_INIT_SERVICENAME, DBPROP_SAS_INIT_MACHINEDNSNAME, and DBPROP_SAS_INIT_PORT.

DBPROP_SAS_INIT_SASEXE

Supported in: SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Executable
Notes:
Use this property to specify the fully qualified path for the SAS executable file (sas.exe) that you use to start a SAS session. The default value might change from one release of the provider to the next. In general, the default path corresponds to the standard installation path of the latest major SAS release.

DBPROP_SAS_INIT_SASPARAMETERS

Supported in: SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Parameters
Note:
Use this property to specify the parameters that are used to invoke SAS. The parameters must include -initstmt, which executes a SAS macro to start the local server. An example is -initstmt %sasodbc(sdplserv) -icon -nologo -notutorialdlg.

DBPROP_SAS_INIT_SASWORKINGDIR

Supported in: SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Working Directory
Note:
Use this property to specify the fully qualified path for the directory that you want to use as the SAS working directory.

DBPROP_SAS_INIT_SERVERPASSWORD

Supported in: SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Server Access Password
Note:
Use this property to specify the server access password when one is needed. Consult your SAS/SHARE server administrator if you are unsure about your server's authentication requirements.

DBPROP_SAS_INIT_SERVERRELEASE

Supported in: SAS/SHARE Provider, Base SAS Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): SAS Server Release
Notes:
Use this property to specify the SAS release of the server that you intend to use. The value of this property can be 7, 8 or 9. The value should correspond to the major release number of the connected server. Consult your SAS/SHARE server administrator if you are unsure of your server's release number.

DBPROP_SAS_INIT_SERVERTYPE

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): SAS Server Type
Notes:
Use this property to specify the type of SAS server that you want to connect to. This value can be DBPROPVAL_DST_TDP for a tabular data server or DBPROPVAL_DST_MDP for an OLAP server. Contact your system administrator if you are unsure about the server type.

DBPROP_SAS_INIT_SERVICENAME

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Service Name
Notes:
Use this property to identify the TCP/IP service name to use on the SAS Workspace Server.
This name is used to look up the port on the machine that is hosting the SAS Workspace Server. When connecting to a remote SAS Workspace Server, use this property in conjunction with DBPROP_SAS_INIT_MACHINEDNSNAME and DBPROP_SAS_INIT_PROTOCOL. This value is functionally equivalent to DBPROP_SAS_ INIT_ PORT.

DBPROP_SAS_INIT_WORKSPACE

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_UNKNOWN
Description (ADO property name): SAS Workspace Interface
Notes:
This property is no longer supported. Use DBPROP_SAS_INIT_WORKSPACEID instead.

DBPROP_SAS_INIT_WORKSPACEID

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Workspace ID
Notes:
Use this property to specify the UniqueIdentifier for a SAS workspace.
When connecting to an existing SAS workspace, set this property equal to the UniqueIdentifier of the workspace. UniqueIdentifier is a property on the SAS IOM workspace object.

DBPROP_SAS_INIT_WORKSPACE_INIT_SCRIPT

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_DBINIT
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Workspace Init Script
Notes:
You can use this BSTR Data Source Initialization property to hold SAS code that will be submitted for execution to a SAS Workspace server immediately after a connection is to the server is established. The code can be any valid SAS code.

DBPROP_SAS_LIBOPTS

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Library Options
Notes:
Use this property to specify any LIBNAME or engine options that should be used when opening this rowset.
When this property is set, DBPROP_SAS_PATH must also be set. If DBPROP_SAS_PATH is set and the libref is not specified as part of the rowset's TableID, then the IOM Provider assigns a libref on the SAS Workspace Server. The options specified by this property are applied to the libref assignment. The libref is unassigned when the rowset is released.

DBPROP_SAS_MISSING_VALUES

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): SAS Missing Values

DBPROP_SAS_NLSOPTS

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): SAS NLS Options
Notes:
Use this property to specify how strings will be handled by the provider.

DBPROP_SAS_OPTIMISTICLOCKING

Supported in: IOM Provider, OLAP Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): SAS Optimistic Locking
Notes:
Use this property to control whether a data set is opened with SAS member-level access or SAS record-level access. A value of VARIANT_TRUE indicates record-level access; a value of VARIANT_FALSE indicates member-level access.
When a file is opened for record-level access, the server uses a record-locking strategy, which means that exclusive update privileges are acquired on a per record basis. This setting enables multiple users to access the same file simultaneously. When a file is opened with member-level control, the server grants exclusive access to the entire file (for example, data set), which prevents other users from updating the file.

DBPROP_SAS_PAGESIZE

Supported in: IOM Provider, OLAP Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): SAS Page Size
Notes:
Use this property to set the number of rows in a single page of data retrieved from the server. A value of 0 disables paging. If the DBPROP_SAS_PAGESIZE property is set to -1, then the provider attempts to cache the entire data set when it reads the data set for the first time. Your application must ensure that there is enough RAM for this operation to succeed.

DBPROP_SAS_PATH

Supported in: IOM Provider, OLAP Provider
Property Group: Initialization
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Physical Path
Notes:
Use this property to specify the host file system path for the location of the table referenced by this rowset (such as a directory).
The path form depends on the platform that is hosting the server and the conventions of the selected engine. The engine usually requires you to specify an existing location on the server machine.
When this property is set and the libref is not specified as part of the rowset's TableID, the provider assigns a libref on behalf of the client. The path of the libref is specified by this property. The optional properties DBPROP_SAS_ENGINE and DBPROP_SAS_LIBOPTS are also used to assign the new libref. The libref is unassigned when the rowset is released.

DBPROP_SAS_PHYSICALPOSITIONING

Supported in: IOM Provider, OLAP Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): SAS Physical Positioning
Notes:
This property determines which positioning model is used by the IOM provider. When this property is FALSE, then standard OLE DB logical positioning is used. When this property is TRUE, the SAS physical positioning model is used. By default, this property is FALSE.
When offsets are being calculated, positioning is handled in these ways:
  • Logical positioning does not count deleted records.
  • Physical positioning does count deleted records.

DBPROP_SAS_PT2DBPW

Supported in: SAS/SHARE Provider, Base SAS Provider
Property Group: Session
Property Set: DBPROPSET_SAS_SESSION
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS PT2DBPW
Notes:
Use this property to enable the processing of SQL queries on remote databases. Set it to the same value that is specified in the PT2DBPW option in the PROC SERVER statement.
This property must be set whenever the PT2DBPW option is specified in the PROC SERVER statement and you are using a DBPROP_SAS_SQLENGINE value other than the default of SQLVIEW.

DBPROP_SAS_READPASSWORD

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Read Password
Notes:
Use this property to specify the read password when you access a read-protected SAS file.
For more information about the SAS data set password facility, see "File Protection" in SAS Language Reference: Concepts.

DBPROP_SAS_RESERVED_ROWSETFLAGS

Supported in: IOM Provider, OLAP Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): SAS Reserved 1
Notes:
Reserved for future use.

DBPROP_SAS_SQLCONNECTIONSTRING

Supported in: IOM Provider, OLAP Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Session
Property Set: DBPROPSET_SAS_SESSION
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS SQL Engine Options
Notes:
When you are creating a Command object, use this property to specify SAS options to associate with the DBMS engine. Use this property when DBPROP_SAS_SQLENGINE is set to a value other than its default SQLVIEW value.

DBPROP_SAS_SQLENGINE

Supported in: IOM Provider, OLAP Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Session
Property Set: DBPROPSET_SAS_SESSION
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS SQL Engine
Notes:
When you are creating a Command object, use this property to identify which DBMS engine to use.

DBPROP_SAS_USE_TKMANAGER_SEARCHPATH

Supported in: Local Provider
Property Group: Data Source Information
Property Set: DBPROPSET_SAS_DATASOURCEINFO
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): Use TK Manager Search Path
Notes:
This property indicates that the Threaded Kernel Path has been set in the TKMANAGER_SEARCH_PATH environment variable and that the Threaded Kernel Manager is to be used. TKMANAGER_SEARCH_PATH must contain the fully qualified path to the Threaded Kernel Manager DLL (tkmanager.dll) as the first path, followed by the fully qualified paths for all of the Threaded Kernel files required by the provider. This property is FALSE by default.

DBPROP_SAS_WHERE

Supported in: SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Where
Notes:
Use this property to set a SAS WHERE clause on the rowset. When a WHERE clause is used, the rowset returns only rows that meet the condition that is specified by the WHERE clause. The WHERE clause is limited to forward-only access. It cannot be used with a client-side cursor.
This property is the most efficient way to subset a data set because the filtering process is done on the server. Only rows that match the WHERE-clause criteria are transmitted from the server to the client. Other rowset filtering methods are done in the client process, which means that rows that do not meet the criteria are transmitted from the server to the client.
For more information about WHERE-clause processing, see SAS Language Reference: Concepts and the Base SAS Procedures Guide.

DBPROP_SAS_WORKSPACE_INIT_LIST

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_SAS_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Workspace Init List
Notes:
You can use this read-only BSTR Data Source property to capture the results of the SAS listing for SAS code that was submitted by using the DBPROP_SAS_INIT_WORKSPACE_INIT_SCRIPT (the "SAS Workspace Init Script”) property.

DBPROP_SAS_WORKSPACE_INIT_LOG

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_SAS_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Workspace Init Log
Notes:
You can use this read-only BSTR Data Source property to capture the SAS log for SAS code that was submitted by using the DBPROP_SAS_INIT_WORKSPACE_INIT_SCRIPT (the "SAS Workspace Init Script”) property.

DBPROP_SAS_WRITEPASSWORD

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_SAS_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BSTR
Description (ADO property name): SAS Write Password
Notes:
Use this property to specify the write password when accessing a write-protected SAS file.
For more information about the SAS data set password facility, see "File Protection" in SAS Language Reference: Concepts.

DBPROP_SESS_AUTOCOMMITISOLEVELS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Session
Property Set: DBPROPSET_SESSION
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): Autocommit Isolation Levels
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_SORTONINDEX

Supported in: Local Provider
Property Group: Rowset
Property Set: DBPROPSET_VIEW
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Sort on Index
Notes:
Experimental.

DBPROP_SUPPORTEDTXNISOLEVELS

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Isolation Levels
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

DBPROP_UNIQUEROWS

Supported in: SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_BOOL
Description (ADO property name): UniqueRows
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK. This property was added to support client-side cursors in ADO applications.

DBPROP_UPDATABILITY

Supported in: IOM Provider, OLAP Provider, Local Provider, SAS/SHARE Provider, Base SAS Provider
Property Group: Rowset
Property Set: DBPROPSET_ROWSET
Read: Yes
Write: Yes
Column: False
Type: VT_I4
Description (ADO property name): Updatability
Notes:
For more information, see the OLE DB Programmer’s Reference and Data Access SDK.

MDPROP_AGGREGATECELL_UPDATE

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for updating aggregated cells
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_AXES

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Number of axes in the data set
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_FLATTENING_SUPPORT

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Flattening Support
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_CASESUPPORT

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for MDX case statements
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_DESCFLAGS

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for various <desc flag> values in the DESCENDANTS function
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_FORMULAS

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for creation of named sets and calculated members
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_JOINCUBES

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for query joining multiple cubes
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_MEMBER_FUNCTIONS

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for various member functions
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_NUMERIC_FUNCTIONS

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for various numeric functions
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_OBJQUALIFICATION

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Provider's ability to qualify a cube name
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_OUTERREFERENCE

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for outer Reference in an MDX statement
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_QUERYBYPROPERTY

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_BOOL
Description (ADO property name): Support for querying by property values in an MDX statement
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_SET_FUNCTIONS

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for various set functions
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_SLICER

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): The capabilities in the WHERE clause of an MDX statement
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_MDX_STRING_COMPOP

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for string comparison operators other than equals and not-equals operators
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_NAMED_LEVELS

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for named levels
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.

MDPROP_RANGEROWSET

Supported in: IOM Provider, OLAP Provider
Property Group: Data Source Information
Property Set: DBPROPSET_DATASOURCEINFO
Read: Yes
Write: No
Column: False
Type: VT_I4
Description (ADO property name): Support for cell updates
Notes:
For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of the OLE DB Programmer’s Reference and Data Access SDK. Also see the SAS OLAP Server: MDX Guide.
Copyright © SAS Institute Inc. All rights reserved.