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