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.
Controls
-
OLE DB
Syntax
|
1 |
PersistSensitive='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the data source can
|
Default
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.DbParameter="PersistSensitive='True'"