PersistEncrypted

Description

Specifies whether the data source you are accessing through the OLE DB interface is allowed to save your encrypted password.

When to specify PersistEncrypted

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

Applies to

OLE DB

Syntax

PersistEncrypted='value'

Parameter

Description

value

Specifies whether the data source can save your encrypted password. Values are:

  • True

    Tells the data source it can save your password.

  • False

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


Default value

PersistEncrypted='False'

Examples

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

  • Database profile

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

  • Application

    Type the following in code:

    SQLCA.DBParm="PersistEncrypted='True'"

See also

DataLink

MaskPassword

EncryptPassword

PersistSensitive