Database   Connect to the database using a user ID and password.

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.

Host   Specify the computer name on which the database server is running. You can also click Recent to choose a recently-used host and port combination. See Host connection parameter.

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.

Server name   Type the name of the SQL Anywhere network database server. For example, demo12. You must supply a database server name if you want to connect to a network server.

You can choose a recently-used database server name from the dropdown list or click Find to search for a server. See ServerName (Server) connection parameter.

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:

• DatabaseName (DBN) connection parameter
• Utility database connections

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).

Setup Windows Mobile proxy port   This tool helps you set up a TCP/IP port redirector for connecting to Windows Mobile databases (if Windows Mobile services are installed). This tool is only available if you have Microsoft ActiveSync installed and are connecting to a SQL Anywhere or UltraLite database.