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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » ODBC Configuration Dialog Help » SQL Anywhere ODBC driver

ODBC Configuration dialog: ODBC tab Next Page

ODBC Configuration dialog: Login tab


The Login tab of the ODBC Configuration dialog Login 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.

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

Data source name    This option only appears when you open this dialog 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 dialog 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. You can click Browse to locate an ODBC data source.