Specifies whether the OLE DB data provider can cache sensitive authentication information, such as a password, in an internal cache.
When to specify CacheAuthentication
You must specify the CacheAuthentication parameter before connecting
to the database.
OLE DB
CacheAuthentication='value'
Parameter |
Description |
|---|---|
value |
Specifies whether the OLE DB data provider can cache authentication information. Values are:
|
CacheAuthentication='False'
To tell the OLE DB data provider to cache authentication information:
Database profile Select the Cache Authentication check box on the Security page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="CacheAuthentication='True'"
