ODBC Configuration for SQL Anywhere window: Login tab

This tab has the following components:

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

        Note

        It is recommended that you do not include the password in the data source as it is a significant security risk.

      • Encrypt password   Select this option if you want the password to be stored in encrypted form in the profile.

        This option only appears when creating ODBC data sources. It does not appear when you access this window using the dbmlsync utility.

        For more information, see EncryptedPassword (ENP) connection parameter.

    • Windows Integrated Login   Choose this option to connect to the database using an integrated login on Microsoft Windows. When you choose this option, your 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.

  • Action   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   Connects to a database using an ODBC data source.

    • Connect To A Running Database On Another Computer   Connects to a database that is currently running on a 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.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0