Resources

Opening a Password-Protected Data Set

In this recipe, you learn how to open a data set that requires a password. Sample code for the ADO recipe is included.

Applies to: SAS Local Data Provider, SAS/SHARE Data Provider, SAS IOM Data Provider
Implement using: ADO or OLE DB

Overview

If you need to specify a password to open a data set, use the appropriate customized rowset password property. The following sample code uses the ADO "SAS Read Password" property to open a read-protected data set. Assume that the connection is already open.

Note: For information about how to open a Connection object, see Opening an ADO Connection Object.



obRecordset.ActiveConnection = obConnection 
obRecordset.Properties("SAS Read Password") = "password"  
obRecordset.Open source, , adOpenStatic, adLockReadOnly, adCmdTableDirect

Note: The second parameter must remain empty, as shown in the code fragment.


Details

SAS supports three types of data set passwords: READ, WRITE, and ALTER. The SAS Data Providers implement three properties that correspond to each of the password types.

The following table lists the ADO Recordset property names and their corresponding OLE DB property names. The OLE DB properties are part of the DBPROP_SAS_ROWSET customized property set (see OLE DB Properties: Group Index).

ADO Recordset Property Name OLE DB Rowset Property Name SAS Data Set Property
SAS Read Password DBPROP_SAS_READPASSWORD READ=
SAS Write Password DBPROP_SAS_WRITEPASSWORD WRITE=
SAS Alter Password DBPROP_SAS_ALTERPASSWORD ALTER=

Note: See SAS 9.1 Language Reference: Concepts for complete information about SAS data set passwords.