PersistSensitive

Description

Specifies whether the data source you are accessing through the OLE DB interface is allowed to save sensitive authentication information, such as a password, along with other authentication information.

When to specify PersistSensitive

You must specify the PersistSensitive parameter before connecting to the database.

Applies to

OLE DB

Syntax

PersistSensitive='value'

Parameter

Description

value

Specifies whether the data source can save your authentication information. Values are:

  • True

    Tells the data source it can save your authentication information.

  • False

    (Default) Tells the data source it cannot save your authentication information.


Default value

PersistSensitive='False'

Examples

To tell the data source you are accessing through OLE DB that it can save your authentication information:

  • Database profile

    Select the Persist Security Info check box on the Security page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="PersistSensitive='True'"

See also

MaskPassword

EncryptPassword

PersistEncrypted