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 tab in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DbParameter = "CacheAuthentication='True'"
