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

SQL Anywhere 12.0.0 (Français) » 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:

    • Tester la connexion   Cet outil vérifie si les informations fournies permettent une connexion correcte. Il n'est disponible que lorsque vous vous connectez à une base de données SQL Anywhere.

    • Copier la chaîne de connexion dans le Presse-papiers   Cet outil copie dans le Presse-papiers la chaîne de connexion créée en fonction des informations fournies dans la fenêtre Connexion.

    • Enregistrer en tant que source de données ODBC   Cet outil crée une source de données ODBC en fonction des informations fournies. Reportez-vous à la section Create ODBC data sources using the Connect window.

    • Configurer le port proxy de Windows Mobile   Cet outil permet de configurer un redirecteur de port TCP/IP pour la connexion aux bases de données Windows Mobile (si les services Windows Mobile sont installés). Il n'est disponible que si Microsoft ActiveSync est installé et que vous vous connectez à une base de données SQL Anywhere ou UltraLite.

  6. Click Connect.

 See also

Open the Connect window