Choose 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 Windows integrated logins.
Use the action Connect to a running database in a cloud when you want to connect to a database that is already running in a cloud configuration.
When this action is chosen, the following options are available:
Host Specify the computer name on which the database is running. You can also click Recent to choose a recently-used host and port combination. See Host connection parameter.
Ping Click to test that a computer with the given host name can be found on your network.
Port If your database server is not using the default port of 2638, you must specify the port it is using. You can also click Recent to choose a recently-used host and port combination from the dropdown list.
Database name Type the name of the database you are connecting to, or choose a recently-used database name from the dropdown list.
You only need a database name if there is more than one database running on the database server. Each database running on a database server is identified by a database name.
For more information about the database name, see:
The following tools are available:
Test Connection This tool tests whether the information provided results in a proper connection. This tool is only available when you are connecting to a SQL Anywhere database.
Click Show Details to see debugging information about how the connection parameters are used to find the database server.
Copy Connection String to Clipboard This tool copies the connection string, which is based on the information provided to the clipboard.
Save as ODBC Data Source This tool creates an ODBC data source based on the information provided. See Creating an ODBC data source (Sybase Central and Interactive SQL).
If required, you can click Advanced to specify options such as TCP/IP, encryption, and other advanced options. You can also click Advanced to specify options that allow you to connect to a tenant database's mirror or copy node in the cloud. See Connect window: Connect to a SQL Anywhere database:Advanced options tab and Connect window: Connect to a SQL Anywhere database: Network tab.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|