password-string
Passwords have a maximum length of 255 bytes and are case sensitive. Passwords cannot include leading spaces, trailing
spaces, or semicolons.
Every user of a database has a password. The password must be supplied for the user to be allowed to connect to the database.
User IDs cannot:
begin with white space, single quotes, or double quotes
end with white space
contain semicolons
Passwords are case-sensitive and they cannot:
begin with white space, single quotes, or double quotes
end with white space
contain semicolons
be longer than 255 bytes in length
The Password (PWD) connection parameter is not encrypted. An application can include the 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 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.
On Unix, data source information is stored in a system information file (named .odbc.ini by default). For more information about how this system information file is located, see ODBC data sources on Unix.
Syntax