EncryptedPassword connection parameter [ENP]

Function

Provides a password, stored in an encrypted fashion in a data source.

Usage

Anywhere. (DSN and FILEDSN connection parameters do not support verbose form of keyword.)

Values

String

Default

None

Description

Data sources are stored on disk as a file or in the registry. Storing passwords on disk may present a security problem. For this reason, when you enter a password into a data source, it is stored in an encrypted form.

If both Password and EncryptedPassword are specified, Password takes precedence.

See also

“How connection parameters work”