EncryptedPassword connection parameter [ENP]

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

Usage

Anywhere

Values

String

Default

None

Remarks

Caution

Data sources are stored on disk as a file or in the registry. Storing passwords in clear text or using an encrypted password is a significant security risk. It is not recommended if there is any sensitive data stored in the database. When you enter a password into a data source, it can be stored in an encrypted form to provide slightly more security than storing it in clear text.

On Unix, this information is stored in the system information file (named .odbc.ini by default).

For more information about how the system information file is located, see Using ODBC data sources on Unix.

If both the Password (PWD) connection parameter and the EncryptedPassword (ENP) connection parameter are specified, Password (PWD) takes precedence.