Change database typeIf present, click to connect to an UltraLite database or a generic ODBC database.
AuthenticationChoose one of the following options to connect to the SQL Anywhere database:
Database Connect to the database using a user ID and password.
User ID Type a user ID for the connection. The user ID you supply must have permissions on a database to connect. See Userid (UID) connection parameter.
The default user ID for SQL Anywhere databases is DBA.
Password Type a password for the connection. The password must be the correct password for the user ID you supply. Passwords are case sensitive. See Password (PWD) connection parameter.
The default password for SQL Anywhere databases is sql when you connect with the default user, DBA.
Windows Integrated Login Choose this option to connect to the database using an integrated login on Microsoft Windows. When you choose this option, your Microsoft Windows user ID and password are supplied to the SQL Anywhere integrated login mechanism.
To use integrated logins, you must have been granted integrated login permission on the database and the database server must be set up to accept integrated logins. See Using Windows integrated logins.
ActionUse the action Connect With A Connection String when you want to connect to a database using a connection string.
When this action is chosen, the following options are available:
Parameters Choose this action when your connection string uses an ODBC data source or ODBC data source file, as well as other connection parameters.
Type connection parameters in a semicolon delimited list of parameter=value pairs:
parameter1=value1;parameter2=value2;... |
For example:
DSN=SQL Anywhere 12 Demo";Server=SampleServer; |
Any information you enter in the Parameters field, such as the user ID or database name, takes precedence over the parameters stored in an ODBC data source or an ODBC data source file.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |