OLE DB Provider Properties (Alphabetical Order)

For the following properties, when Read or Write are listed as Yes, you can Read or Write the value of that property. When Column is listed as True you can set the property on individual columns, when Column is listed as false, you can only set the property on the entire rowset.

DBPROP_APPENDONLY Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: Append-Only Rowset Notes:  See the OLE DB documentation.

DBPROP_AUTH_PASSWORD Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Initialization Property Set: DBPROPSET_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: Password Notes:  Set this property to the password value 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: Set this property to the user login password when connecting to a remote IOM server. You do not need to set this property when you are connecting to an existing workspace (via the DBPROP_SAS_INIT_WORKSPACE property) or instantiating a new local server (i.e., when DBPROP_INIT_DATASOURCE is set to "_LOCAL_".) Share Provider: Set this property to the user login password when connecting to a SHARE server which requires user authentication. Consult your SAS/SHARE server administrator if you are not sure about your server's authentication requirements. See The OLE DB Programmer's Reference for more details on this property.

DBPROP_AUTH_USERID Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Initialization Property Set: DBPROPSET_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: User ID Notes:  Set this property to the user login id to use when connecting to a server. Use this property in conjunction with the DBPROP_AUTH_PASSWORD property. Local Provider: This property is ignored by the Local Provider. IOM Provider: Set this property to the user login id when connecting to a remote IOM server. You do not need to set this property when you are connecting to an existing workspace (via the DBPROP_SAS_INIT_WORKSPACE property) or instantiating a new local server (i.e., when DBPROP_INIT_DATASOURCE is set to "_LOCAL_".) Share Provider: Set this property to the user login id when connecting to a SHARE server which requires user authentication. Consult your SAS/SHARE server administrator if you are not sure about your server's authentication requirements. See The OLE DB Programmer's Reference for more details on this property.

DBPROP_BOOKMARKS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: Use Bookmarks Notes:  See the OLE DB documentation.

DBPROP_BOOKMARKSKIPPED Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: Skip Deleted Bookmarks Notes:  See the OLE DB documentation.

DBPROP_BOOKMARKTYPE Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_I4 Description: Bookmark Type Notes:  See the OLE DB documentation.

DBPROP_BYREFACCESSORS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Data Source Information Property Set: DBPROPSET_DATASOURCEINFO Read: Yes Write: No Column: False Type: VT_BOOL Description: Pass By Ref Accessors Notes:  See the OLE DB documentation.

DBPROP_CANFETCHBACKWARDS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: Fetch Backwards Notes:  See the OLE DB documentation.

DBPROP_CANHOLDROWS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: Hold Rows Notes:  See the OLE DB documentation.

DBPROP_CANSCROLLBACKWARDS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: Scroll Backwards Notes:  See the OLE DB documentation.

DBPROP_DATASOURCEREADONLY Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Data Source Information Property Set: DBPROPSET_DATASOURCEINFO Read: Yes Write: No Column: False Type: VT_BOOL Description: Read-Only Data Source Notes:  See the OLE DB documentation.

DBPROP_DBMSNAME Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Data Source Information Property Set: DBPROPSET_DATASOURCEINFO Read: Yes Write: No Column: False Type: VT_BSTR Description: DBMS Name Notes:  See the OLE DB documentation.

DBPROP_DBMSVER Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Data Source Information Property Set: DBPROPSET_DATASOURCEINFO Read: Yes Write: No Column: False Type: VT_BSTR Description: DBMS Version Notes:  Local Provider: Indicates the release version of the provider. Returns the same value as DBPROP_PROVIDERVER. IOM and Share Providers: Indicates the release version of the connected server. See The OLE DB Programmer's Reference for more details on this property.

DBPROP_IAccessor Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: IAccessor Notes:  See the OLE DB documentation.

DBPROP_IColumnsInfo Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: IColumnsInfo Notes:  See the OLE DB documentation.

DBPROP_IConvertType Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: IConvertType Notes:  See the OLE DB documentation.

DBPROP_INIT_DATASOURCE Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Initialization Property Set: DBPROPSET_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: Data Source Notes:  Identifies the server or physical disk location to which you wish to connect. Local Provider: Set this property to the physical disk location of the directory containing your data. The directory specification can be a local drive, a mounted drive or an AFS network drive. 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 you want to associate with the connection. Share Provider: Set this property to the name of the SAS/SHARE server to which you are connecting. Consult your SAS/SHARE server administrator if you do not know the server name. See The OLE DB Programmer's Reference for more details on this property.

DBPROP_INIT_LOCATION Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Initialization Property Set: DBPROPSET_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: Location Notes:  Local Provider: This property is ignored by the Local Provider. IOM Provider: This property is ignored by the IOM Provider. Share Provider: Set this property to the DSN name of the node hosting the server when connecting to a server that is running on a different node than the client. See The OLE DB Programmer's Reference for more details on this property.

DBPROP_INIT_MODE Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Initialization Property Set: DBPROPSET_DBINIT Read: Yes Write: Yes Column: False Type: VT_I4 Description: Mode Notes:  This property specifies access permissions to the connected data source. All three 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) See The OLE DB Programmer's Reference for more details on this property.

DBPROP_INIT_PROVIDERSTRING Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Initialization Property Set: DBPROPSET_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: Extended Properties Notes:  See the OLE DB documentation.

DBPROP_IRowset Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: IRowset Notes:  See the OLE DB documentation.

DBPROP_IRowsetChange Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: IRowsetChange Notes:  See the OLE DB documentation.

DBPROP_IRowsetIdentity Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: IRowsetIdentity Notes:  See the OLE DB documentation.

DBPROP_IRowsetInfo Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: IRowsetInfo Notes:  See the OLE DB documentation.

DBPROP_IRowsetLocate Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: IRowsetLocate Notes:  See the OLE DB documentation.

DBPROP_IRowsetUpdate Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: IRowsetUpdate Notes:  See the OLE DB documentation.

DBPROP_IRowsetView Supported in:  Local Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: IRowsetView Notes:  Experimental.

DBPROP_ISupportErrorInfo Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: ISupportErrorInfo Notes:  See the OLE DB documentation.

DBPROP_IViewFilter Supported in:  Local Provider Property Group: Rowset Property Set: DBPROPSET_VIEW Read: Yes Write: Yes Column: False Type: VT_BOOL Description: 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: 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: IViewSort Notes:  Experimental.

DBPROP_LITERALBOOKMARKS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: Literal Bookmarks Notes:  See the OLE DB documentation.

DBPROP_LITERALIDENTITY Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: Literal Row Identity Notes:  See the OLE DB documentation.

DBPROP_MAXOPENROWS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_I4 Description: Maximum Open Rows Notes:  See the OLE DB documentation.

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

DBPROP_MAXPENDINGROWS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_I4 Description: Maximum Pending Rows Notes:  See the OLE DB documentation.

DBPROP_MAXROWS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_I4 Description: Maximum Rows Notes:  See the OLE DB documentation.

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

DBPROP_ORDEREDBOOKMARKS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: Bookmarks Ordered Notes:  See the OLE DB documentation.

DBPROP_OTHERINSERT Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: Others' Inserts Visible Notes:  See the OLE DB documentation.

DBPROP_OTHERUPDATEDELETE Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: Others' Changes Visible Notes:  See the OLE DB documentation.

DBPROP_OWNINSERT Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: Own Inserts Visible Notes:  See the OLE DB documentation.

DBPROP_OWNUPDATEDELETE Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: Own Changes Visible Notes:  See the OLE DB documentation.

DBPROP_PROVIDERVER Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Data Source Information Property Set: DBPROPSET_DATASOURCEINFO Read: Yes Write: No Column: False Type: VT_BSTR Description: Provider Version Notes:  Indicates the release version of the provider. The major release, minor release and build number are encoded in the value returned. Local Provider: Returns the same value as DBPROP_DBMSVER. See The OLE DB Programmer's Reference for more details on this property.

DBPROP_REMOVEDELETED Supported in:  Local Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: No Column: False Type: VT_BOOL Description: Remove Deleted Rows Notes:  See the OLE DB documentation.

DBPROP_SAS_ALTERPASSWORD Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Alter Password Notes:  Use this property to access a read-, write- or alter-protected SAS files.

DBPROP_SAS_BLANKPADDING Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: SAS Preserve Trailing Blanks Notes:  If VARIANT_TRUE when character data is read, 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: SAS Default File Format Notes:  This property defines the default value for DBPROP_SAS_INITFILEFORMAT. It may change from one release of the provider to the next. In general, the default file format indicated by this property corresponds to the data set format of the latest major SAS release.

DBPROP_SAS_ENGINE Supported in:  IOM Provider Property Group: Initialization Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Library Engine Notes:  Specifies the name of the engine to use when opening this rowset. The available engines are dependent 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 this property is not set and DBPROP_SAS_PATH is set, the default engine will be used.

DBPROP_SAS_FMTERR Supported in:  Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: False Type: VT_BOOL Description: 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 , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Formats Notes:  Use this property to format columns of data. The string value given can be one of the following: _ALL_ indicating all variables should be returned as formatted values +_ALL_ indicating all variables should be returned as both formatted and unformatted values or a comma separated list with items of the form [+]COLUMN[=FORMAT[w].[d]] where the optional plus (+) modifier indicates the variable should be returned as both formatted and unformatted values COLUMN is the name of the variable you want to format FORMATw.d is the SAS format you want to apply. If this is not given, the default format is used. 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 , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Informats Notes:  Use this property to informat columns of data. The string value given can be one of the following: _ALL_ indicating all variables should be output using informatted values or a comma separated list with items of the form COLUMN[=INFORMAT[w].[d]] where COLUMN is the name of the variable you write with an informat INFORMATw.d is the SAS informat you want to apply. If this is not given, the default informat is used. 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_FILEFORMAT Supported in:  Local Provider Property Group: Initialization Property Set: DBPROPSET_SAS_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS File Format Notes:  Defines the SAS file format associated with the data source. The Local Provider supports the following file formats Version 6 data sets Versions 7 and 8 data sets Version 5 transport files This property takes a string value indicating which file format to associate with the directory given as the DBPROP_INIT_DATAOUSRCE value. Valid strings for DBPROP_SAS_INIT_FILEFORMAT are "V6" indicating you wish to access Version 6 data sets "V7" indicating you wish to access Version 7 (or Version 8) data sets "V8" indicating you wish to access Version 8 (or Version 7) data sets "XPT" indicating you wish to access 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, the provider attempts to determine which file format to use by examining the data source directory. If a decision can't be made based on the contents of the data source directory, the provider uses the DBPROP_SAS_DEFAULTFILEFORMAT value as the default for DBPROP_SAS_INIT_FILEFORMAT.

DBPROP_SAS_INIT_LOGICALNAME Supported in:  IOM Provider Property Group: Initialization Property Set: DBPROPSET_SAS_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Logical Name Notes:  This property is obsolete and is provided only for backward compatibility.

DBPROP_SAS_INIT_MACHINEDNSNAME Supported in:  IOM Provider Property Group: Initialization Property Set: DBPROPSET_SAS_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Machine DNS Name Notes:  Specifies the network DNS name of the IOM server. Use in conjunction with DBPROP_SAS_INIT_SERVICENAME, DBPROP_SAS_INIT_PROTOCOL and DBPROP_SAS_INIT_PORT when connecting to a remote IOM server.

DBPROP_SAS_INIT_PORT Supported in:  IOM Provider Property Group: Initialization Property Set: DBPROPSET_SAS_DBINIT Read: Yes Write: Yes Column: False Type: VT_I4 Description: SAS Port Notes:  Indicates the TCP/IP port number to use on the machine hosting the IOM server. Use in conjunction with DBPROP_SAS_INIT_MACHINEDNSNAME and DBPROP_SAS_INIT_PROTOCOL to connect to a remote IOM server.Functionally equivalent to DBPROP_SAS_ INIT_ SERVICENAME.

DBPROP_SAS_INIT_PROTOCOL Supported in:  IOM Provider Property Group: Initialization Property Set: DBPROPSET_SAS_DBINIT Read: Yes Write: Yes Column: False Type: VT_I4 Description: SAS Protocol Notes:  Defines how to communicate with the SAS server. One of ProtocolCom, ProtocolCorba, or ProtocolBridge. Use in conjunction with DBPROP_SAS_INIT_SERVICENAME, DBPROP_SAS_INIT_MACHINEDNSNAME and DBPROP_SAS_INIT_PORT when connecting to a remote IOM server.

DBPROP_SAS_INIT_SERVERPASSWORD Supported in:  SHARE Provider Property Group: Initialization Property Set: DBPROPSET_SAS_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: 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:  SHARE Provider Property Group: Initialization Property Set: DBPROPSET_SAS_DBINIT Read: Yes Write: Yes Column: False Type: VT_I4 Description: SAS Server Release Notes:  Use this property to specify the SAS release of the server you intend to use. The value of this property can be 6, 7 or 8; 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_SERVICENAME Supported in:  IOM Provider Property Group: Initialization Property Set: DBPROPSET_SAS_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Service Name Notes:  Indicates the TCP/IP service name to use on the IOM server. This name is used to look up the port on the machine hosting the IOM server. Use it in conjunction with DBPROP_SAS_INIT_MACHINEDNSNAME and DBPROP_SAS_INIT_PROTOCOL when connecting to a remote IOM server.This value is functionally equivalent to DBPROP_SAS_ INIT_ PORT.

DBPROP_SAS_INIT_WORKSPACE Supported in:  IOM Provider Property Group: Initialization Property Set: DBPROPSET_SAS_DBINIT Read: Yes Write: Yes Column: False Type: VT_UNKNOWN Description: SAS Workspace Interface Notes:  Specifies a pointer to a SAS Workspace Object. When connecting to an existing SAS workspace, set this property equal to the SAS Workspace Object. This property cannot be used with ADO.Use DBPROP_SAS_INIT_WORKSPACEID instead. This property is experimental.

DBPROP_SAS_INIT_WORKSPACEID Supported in:  IOM Provider Property Group: Initialization Property Set: DBPROPSET_SAS_DBINIT Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Workspace ID Notes:  Specifies 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 Property Group: Initialization Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Library Options Notes:  Specifies any LIBNAME and/or engine options that are to 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, the IOM Provider assigns a libref on the IOM server. The options specified by this propertywill be applied to the libref assignment. The libref will be deassigned when the rowset is released.

DBPROP_SAS_OPTIMISTICLOCKING Supported in:  IOM Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: True Type: VT_BOOL Description: SAS Optimistic Locking Notes:  Controls 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. I.e., exclusive update privileges are acquired on a per record basis. This allows multiple users of the server 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); this prevents other users from updating the file.

DBPROP_SAS_PATH Supported in:  IOM Provider Property Group: Initialization Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Physical Path Notes:  Specifies the host filesystem pathname for the location of the table referenced by this rowset (such as a directory). The pathname form is dependent upon the platform on which the server is running and the conventions of the selected engine. The engine will often require that this location already exist on the server machine. When this property is set and the libref is not specified as part of the rowset's TableID, the provider will assign a libref on behalf of the client.The pathname of the libref is specified by this property.The optional properties DBPROP_SAS_ENGINE and DBPROP_SAS_LIBOPTS will also be used in the assignment of the new libref. The libref will be deassigned when the rowset is released.

DBPROP_SAS_PT2DBPW Supported in:  SHARE Provider Property Group: Session Property Set: DBPROPSET_SAS_SESSION Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS PT2DBPW Notes:  Used when processing SQL queries through a provider's Command object. Set it to the password for controlling pass-through access to the remote databases specified for the PT2DBPW= option in the PROC SERVER statement. If PT2DBPW= is specified when the server is started, you must specify a value for DBPROP_SAS_PT2DBPW when you use a DBPROP_SAS_SQLENGINE value other than the default of SQLVIEW.

DBPROP_SAS_READPASSWORD Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Read Password Notes:  Use this property to access a read-protected SAS file.

DBPROP_SAS_SQLCONNECTIONSTRING Supported in:  IOM Provider , SHARE Provider Property Group: Session Property Set: DBPROPSET_SAS_SESSION Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS SQL Engine Options Notes:  Contains any SAS options to associate with the DBMS engine when creating a Command object. This is useful when DBPROP_SAS_SQLENGINE is set to a value other than its default SQLVIEW value.

DBPROP_SAS_SQLENGINE Supported in:  IOM Provider , SHARE Provider Property Group: Session Property Set: DBPROPSET_SAS_SESSION Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS SQL Engine Notes:  Tells which DBMS engine to use when creating a Command object.

DBPROP_SAS_WHERE Supported in:  SHARE Provider Property Group: Rowset Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: True Type: VT_BSTR Description: SAS Where Notes:  Use this property to set a SAS WHERE clause on the rowset. When given the rowset only returns rows that meet the condition specified by the WHERE clause. (See the SAS Language Reference for details regarding WHERE clauses.) This property is the most efficient way to subset a data set since the filtering process is done on the server. Only rows matching the WHERE clause criteria are transmitted from the server to the client. Other rowset filtering methods are done in the client process; this results in rows that do not meet the criteria being transmitted from the server to the client.

DBPROP_SAS_WRITEPASSWORD Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_SAS_ROWSET Read: Yes Write: Yes Column: False Type: VT_BSTR Description: SAS Write Password Notes:  Use this property to access a write-protected SAS file.

DBPROP_SESS_AUTOCOMMITISOLEVELS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Session Property Set: DBPROPSET_SESSION Read: Yes Write: Yes Column: False Type: VT_I4 Description: Autocommit Isolation Levels Notes:  See the OLE DB documentation.

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

DBPROP_SUPPORTEDTXNISOLEVELS Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Data Source Information Property Set: DBPROPSET_DATASOURCEINFO Read: Yes Write: No Column: False Type: VT_I4 Description: Isolation Levels Notes:  See the OLE DB documentation.

DBPROP_UPDATABILITY Supported in:  IOM Provider , Local Provider , SHARE Provider Property Group: Rowset Property Set: DBPROPSET_ROWSET Read: Yes Write: Yes Column: False Type: VT_I4 Description: Updatability Notes:  See the OLE DB documentation.

SAS IOM Data Provider