Resources

OLE DB Properties: Alphabetical Listing

In the following list:

Note: Properties specific to SAS begin with DBPROP_SAS_ (for example, DBPROP_SAS_FORMATS). Property sets specific to SAS begin with DBPROPSET_SAS_ (for example, DBPROPSET_SAS_DATASOURCEINFO).

DBPROP_APPENDONLY

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_AUTH_PASSWORD

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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 IOM server, set this property to the user's log-in password. You do not need to set this property when you are connecting to an existing workspace (via the DBPROP_SAS_INIT_WORKSPACE property) or when you are instantiating a new local server (i.e., when DBPROP_INIT_DATASOURCE is set to "_LOCAL_".)

SAS/SHARE Provider: Set this property to the user's log-in password 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_AUTH_USERID

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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 IOM server, set this property to the user's log-in ID. You do not need to set this property when you are connecting to an existing workspace (via the DBPROP_SAS_INIT_WORKSPACE property) or when you are instantiating a new local server (i.e., when DBPROP_INIT_DATASOURCE is set 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_BOOKMARKS

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_BOOKMARKSKIPPED

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_BOOKMARKTYPE

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_BYREFACCESSORS

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_CANFETCHBACKWARDS

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_CANHOLDROWS

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_CANSCROLLBACKWARDS

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_DATASOURCEREADONLY

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_DBMSNAME

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_DBMSVER

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_IAccessor

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_IColumnsInfo

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_IConvertType

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_INIT_DATASOURCE

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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 physical disk location of the directory that contains your data. The directory specification can be a local drive, a mounted drive, or an AFS 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 new, locally instantiated IOM server connection. When creating a remote IOM 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_INIT_HWND

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): Window Handle

Notes: For more information, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_INIT_LOCATION

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_INIT_MODE

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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 four data providers honor the following bitmasks:

Other bitmasks are ignored and the mode is degraded to (DB_MODE_READ | DB_MODE_SHARE_DENY_NONE)

For more information, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_INIT_PROMPT

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_INIT_PROVIDERSTRING

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_IRowset

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_IRowsetChange

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_IRowsetIdentity

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_IRowsetInfo

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_IRowsetLocate

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_IRowsetUpdate

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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

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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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

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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_LITERALIDENTITY

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_MAXOPENROWS

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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

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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_MAXROWS

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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_ORDEREDBOOKMARKS

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_OTHERINSERT

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_OTHERUPDATEDELETE

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_OWNINSERT

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_OWNUPDATEDELETE

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_PROVIDERVER

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, and build number are encoded in the returned value.

Local Provider: Returns the same value as DBPROP_DBMSVER.

For more information, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_REMOVEDELETED

Supported in: Local 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_SAS_ALTERPASSWORD

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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

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_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. It 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

Property Group: Rowset

Property Set: DBPROPSET_SAS_ROWSET

Read: Yes

Write: Yes

Column: False

Type: VT_BOOL

Description (ADO property name): SAS Format Error

Notes: 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, 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

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:

This property is only for use by an ADO client. Direct OLE DB consumers should not use this property to format data.

DBPROP_SAS_INFORMATS

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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:

This property is only for use by an ADO client. Direct 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 will only be used to handle requests for single cells (i.e., 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, this 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:

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:

This property takes a string value that indicates which file format to associate with the directory given as the DBPROP_INIT_DATASOURCE value. Valid strings for DBPROP_SAS_INIT_FILEFORMAT are:

"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 non-Windows platforms. 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 non-Windows SAS data sets, use the default file format or "V9".

DBPROP_SAS_INIT_LOCALSERVER

Supported in: SAS/SHARE 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

Notes: Use this property to determine if the SAS/SHARE provider will start a local server. The value for this property can be 0 or 1. 0 is the default value and indicates that the provider should not start a server. 1 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

Notes: 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 IOM 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 IOM server.

When connecting to a remote IOM 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 IOM 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

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 may 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

Property Group: Initialization

Property Set: DBPROPSET_SAS_DBINIT

Read: Yes

Write: Yes

Column: False

Type: VT_BSTR

Description (ADO property name): SAS Parameters

Notes: Use this property to specify the parameters that are used to invoke SAS. The parameters must include -initstmt, which executes a SAS Macro file to start the local server.

DBPROP_SAS_INIT_SASWORKINGDIR

Supported in: SAS/SHARE 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

Notes: 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

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

Notes: 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

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; it 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 1 (DBPROPVAL_DST_TDP) for a tabular data server or 2 (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 IOM server.

This name is used to look up the port on the machine that is hosting the IOM server. When connecting to a remote IOM 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_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 IOM server. The options specified by this property are applied to the libref assignment. The libref is unassigned when the rowset is released.

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: Sets how strings will be handled by the provider.

DBPROP_SAS_OPTIMISTICLOCKING

Supported in: IOM Provider , OLAP Provider , SAS/SHARE 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 (e.g., 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 calculating offsets:

DBPROP_SAS_PT2DBPW

Supported in: SAS/SHARE 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 on 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

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 9 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

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

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_WHERE

Supported in: SAS/SHARE 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 only returns rows that meet the condition that is specified by the WHERE clause. The WHERE clause is limited to forward-only access. It also cannot be used with a client-side cursor.

Note: See SAS Language Reference: Concepts and the SAS Procedures Guide for more information about WHERE-clause processing.

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.

DBPROP_SAS_WRITEPASSWORD

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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 9 Language Reference: Concepts.

DBPROP_SESS_AUTOCOMMITISOLEVELS

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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

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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

DBPROP_UPDATABILITY

Supported in: IOM Provider , OLAP Provider , Local Provider , SAS/SHARE 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, refer to the OLE DB specification, which is documented in The OLE DB Programmer's Reference, published by Microsoft.

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. 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 dataset

Notes: For more information, see the "OLE DB for Online Analytical Processing (OLAP)" section of The OLE DB Programmer's Reference. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. Also see the SAS 9 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. Also see the SAS OLAP Server: MDX Guide.