SQL Anywhere® Server - Database Administration  > Connection Parameters and Network Protocol Options  > Connection parameters

Password connection parameter [PWD]

Provides a password for a connection.

Anywhere

String

No password provided.

Every user of a database has a password. The password must be supplied for the user to be allowed to connect to the database. Passwords have a maximum length of 255 bytes and are case sensitive. Passwords cannot include leading spaces, trailing spaces, or semicolons.

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 SQL Anywhere ODBC configuration tool both use encrypted passwords.

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

Alternatively, you can set this parameter in the Password text box in the Connect dialog and ODBC Administrator dialog.

• EncryptedPassword connection parameter [ENP]
• GRANT statement
• Case sensitivity
• How connection parameters work
• Connection parameter tips

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

UID=DBA;PWD=sql