EncryptedPassword (ENP) connection parameter

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

Syntax

{ EncryptedPassword | ENP }=password

Remarks

Every user of a database has a password. The password must be supplied for the user to be allowed to connect to the database.

The EncryptedPassword (ENP) connection parameter is used to specify an encrypted password. An application may include the encrypted password in the connection string. If both the Password (PWD) connection parameter and the EncryptedPassword (ENP) connection parameter are specified, the Password (PWD) connection parameter takes precedence.

Caution

When creating a data source, it is recommended that you do not include the encrypted password as part of the definition. Although both the ODBC Configuration For SQL Anywhere window in the Windows ODBC Data Source Administrator and the SQL Anywhere Data Source utility (dbdsn) have this capability, including this information poses a security risk.

You can encrypt a password that is stored in an ODBC data source by using the -pe option with the Data Source utility (dbdsn). See Data Source utility (dbdsn).

On Unix, data source information is stored in a system information file (named .odbc.ini by default).

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