Provides a password for a connection.
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 window and ODBC Configuration For SQL Anywhere 11 window.
Storing the password in a DSN or text file is a significant security risk. It is not recommended if there is any sensitive data stored in the database. Sybase Central and the SQL Anywhere ODBC Configuration tool both store the password in a DSN using encrypted passwords, but even encrypted passwords provide only a low level of security.
The following connection string fragment supplies the user ID DBA and password sql.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|