Password Connection Parameter [PWD]

Provides a password for the connection.

Usage

Anywhere

Default

No password provided

Description

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

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

If you specify 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.