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

SAP Sybase SQL Anywhere 16.0 » Context-Sensitive Help » ODBC Configuration window help » SQL Anywhere ODBC driver

 

ODBC Configuration/DBMLSync Setup 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 privilege on the database and the database server must be set up to accept integrated logins. See Windows integrated logins.

  • Action   From the Action dropdown list, choose a connection type:

    • Connect To A Running Database On This Computer   When this action is chosen, the following options are available:

      • Server name   Type the name of the SQL Anywhere personal database or network database server. For example type, demo16.

        You must supply a database server name to connect to a network server. If you are connecting to the default personal server, you can omit the database server name. See Database server names and database names and ServerName (Server) connection parameter.

      • Database name   Type the name of the database you are connecting to. For example, type demo. Each database running on a database server is identified by a database name. See DatabaseName (DBN) connection parameter.

    • Connect To A Running Database On Another Computer   When this action is chosen, the following options are available:

      • Host   Specify the computer name on which the database server is running. 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.

      • Server name   Type the name of the SQL Anywhere network database server. For example, type demo16. You must supply a database server name to connect to a network server.

      • Database name   Type the name of the database you are connecting to.

        You need a database name only 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:

    • Connect to a running database in a cloud   When this action is chosen, the following options are available:

      • Host   Specify the computer name on which the database server is running. 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.

      • Database name   Type the name of the database you are connecting to.

        You need a database name only 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:

    • Start And Connect To A Database On This Computer   When this action is chosen, the following options are available:

      • Database file   Type the full path and name of the database file. For example type, C:\sample.db. Otherwise, the path of the file is relative to the working directory of the database server.

        See DatabaseFile (DBF) connection parameter.

      • Encryption key   If the database file is encrypted, you must supply a key to the database server every time the database server starts the database. See DatabaseKey (DBKEY) connection parameter.

      • Database name   Type the name of the database you are connecting to. Otherwise, a default name is assigned to the database. This default name is the root of the database file. For example, a database with the file name C:\Database Files\demo.db would be given the default name of demo.

        Each database running on a database server is identified by a database name. See Database server names and database names and Connecting to the utility database.

      • Server name   Type the name of the SQL Anywhere personal server that you are starting. For example, type demo. If you are connecting to the default personal server, you can omit the database server name.

        See Database server names and database names and ServerName (Server) connection parameter.

        Note

        To start a network server, you must use the Start line field.

      • Start line   Type a command to start a personal or a network database server on your computer.

        • Personal database server   Enter a start line only if you want to connect to a local database server that is not currently running and if you want to set your own start parameters.

          For example to start the personal database server, enter C:\Program Files\SQL Anywhere 16\Bin32\dbeng16.exe -c 8M. . See StartLine (START) connection parameter.

        • Network database server   Type a start line to start a network database server on this computer.

          For example to start the network database server, enter C:\Program Files\SQL Anywhere 16\Bin32\dbsrv16.exe -x none.

          For more information, see StartLine (START) connection parameter.

        You can also include options in the Start Line field. Use the Start Line and options when you want to:

        • Employ any advanced server features.

        • Control protocol options.

        • Provide diagnostic or troubleshooting messages.

        • Set permissions.

        • Set database parameters (including encryption).

        For more information about options you can specify in the Start Line field, see SQL Anywhere database server syntax.

      • Stop database after last disconnect   Select this option to automatically shut down the database after the last user disconnects. See AutoStop (ASTOP) connection parameter.

    • Start And Connect To A Database On Another Computer   When this action is chosen, the following options are available:

 See also