Password connection parameter [PWD]

Function

To provide a password for the connection.

Usage

Anywhere

Default

No password provided

See also

“EncryptedPassword connection parameter [ENP]”

Description

Every user of a database has a password. The password must be supplied for the user to be allowed to connect to the database. By default, the password has the same case sensitivity as the data. IQ databases are case sensitive by default.

The password parameter is not encrypted. If you are storing passwords in a connection profile, you should use the EncryptedPassword parameter. Sybase Central and the Sybase IQ ODBC configuration tool both use encrypted parameters.

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

Examples

The following connection string fragment supplies the user ID DBA and password SQL.

uid=DBA;pwd=SQL

Alternatively, you can set these parameters in the User ID and Password text boxes in the connection window.