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 » Connect Dialog Help

Introduction to the Connect dialog Next Page

Connect dialog: Identification tab (SQL Anywhere)

The Identification tab of the Connect dialog has the following components:

Supply user ID and password    Select this option to specify a user ID and password for the connection.

Use integrated login    Select this option to connect to the database using an integrated login on Windows.

If you select this option, your database user ID and password do not need to be specified: instead, 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.


None    Select this option if you are not using an ODBC data source for the connection.

ODBC Data Source name    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.

You can also select a recently used ODBC data source from the dropdown list.



ODBC data sources allow you to store connection information. If you have connection information stored in an ODBC data source, do not repeat this information in the Connect dialog. For example, if the ODBC data source already contains a user ID, then do not supply the user ID in the User ID field of the Connect dialog.


Any information you enter in the Connect dialog, such as the user ID or database name, takes precedence over the parameters stored in an ODBC data source or an ODBC data source file.

ODBC Data Source file    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 also select a recently used ODBC Data Source File from the dropdown list.

File data sources hold the same information as ODBC data sources stored in the registry.

See FileDataSourceName connection parameter [FILEDSN].

Tools    The following utilities are available from the Tools button:

See Working with ODBC data sources.

See also