ASA Database Administration Guide
  Connection and Communication Parameters
    Connection parameters

Password connection parameter [PWD]

Function 

To provide a password for the connection.

Usage 

Anywhere

Values 

String

Default 

No password provided.

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.

The Password (PWD) connection parameter is not encrypted. If you are storing passwords in a data source, you should use the EncryptedPassword (ENP) connection parameter. Sybase Central and the Adaptive Server Anywhere ODBC configuration tool both use encrypted parameters.

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

Example 

• 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 Connect dialog and ODBC Administrator dialog.

See also 

EncryptedPassword connection parameter [ENP]