Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » SQL Anywhere database connections

 

Working with the Connect window

When connecting to a server or database from Sybase Central, Interactive SQL, or the SQL Anywhere Console utility, you use the Connect window to specify connection parameters. Information you enter in the Connect window is preserved between sessions.

The connection parameters you specify in the Connect window are dependent on the connection type.

The Connect window
 To connect to a database using the Connect window
  1. If required, click Change Database Type and choose a database type. For example, to connect to a SQL Anywhere database, select SQL Anywhere.

  2. In the Authentication dropdown list, choose either Database to connect using your user ID and password or Windows Integrated Login to connect using your Windows Integrated Login.

    If you choose Database, then:

    1. In the User ID field, type a user name. For example, type DBA.

    2. In the Password field, type a password for the database. For example, type sql.

  3. From the Action dropdown list, choose a connection type:

    • Connect To A Running Database On This Computer   Connects to a database that is already running on your computer.

    • Connect With An ODBC Data Source   Connect to a database using an ODBC data source.

    • Connect To A Running Database On Another Computer   Connects to a database that is running on another computer in the network.

    • Start And Connect To A Database On This Computer   Starts a database on this computer and connects to it.

    • Start And Connect To A Database On Another Computer   Starts a database over a network on another computer and connects to it.

    • Connect With A Connection String   Connects to a database using a connection string.

    The connection parameters below the Action dropdown list , which are also chosen in this step change depending upon your choice.

  4. If required, you can click Advanced to specify options such as TCP/IP, encryption, and other advanced options.

    The Connect window with the Identification, Network, and Advanced Options tabs showing.
  5. If required, click Tools, to access the following tools:

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

    • 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 Create ODBC data sources using the Connect window.

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

  6. Click Connect.

 See also

Open the Connect window