PersistSensitive
database parameter
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
|
1 |
PersistSensitive='value' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the data source can save your
|
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:
1SQLCA.DBParm="PersistSensitive='True'"
See also