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.
OLE DB
PersistSensitive = 'value'
PersistSensitive = 'False'
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 tab in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="PersistSensitive='True'"
