Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.0 » Context-Sensitive Help » ODBC Configuration window help » SQL Anywhere ODBC driver

 

ODBC Configuration window: Login tab

This tab has the following components:

Use integrated login   Select this option to connect using an integrated login.

If you select this option, the user ID and password do not need to be specified: instead, your operating system user ID and password are supplied to the SQL Anywhere integrated login mechanism.

To use integrated logins, users must have been granted integrated login permission and the database you are connecting to must also be set up to accept integrated logins. Only users with DBA access may administer integrated login permissions.

For more information, see Using integrated logins.

Supply user ID and password   Select this option if you want to specify the user ID and password for the connection.

  • User ID   Type a user ID for the connection. The user ID you supply must have permissions on a database to connect.

  • Password   Type a password for the connection. The password must be the correct password for the user ID you supply. The password is case sensitive.

    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 connection parameter [ENP].

Data source name   This option only appears when you open this window using the dbmlsync utility. Select this option to choose a data source (a stored set of connection parameters) for connecting to your database. This field is equivalent to the DSN connection parameter, which references a data source in the registry. You can view a list of data sources by clicking Browse.

Data source file   This option only appears when you open this window using the dbmlsync utility. Select this option to choose a data source file for the connection. You can search for the file by clicking Browse. The ODBC data source file is often used for Unix systems.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0