Description
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.
Applies to
OLE DB
Syntax
CacheAuthentication='value'
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the OLE DB data provider can cache authentication information. Values are:
|
Default value
CacheAuthentication='False'
Examples
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'"
See also
