The Identification tab has the following components:
Supply user ID and password Select this option to specify a user ID and password for the connection.
User ID – type a user ID for the connection. The default user ID is dba. The user ID must have permissions to connect to the database.
Password – type a password for the connection. The default password for the iqdemo database is sql when you connect with the default user, dba. Passwords are case-sensitive.
Use integrated login Select this option to connect to the database using an integrated login on Windows. To use this option, the DBA must define an integrated login for you. See “Using an integrated login” in Chapter 3, “Sybase IQ Connections” in the System Administration Guide: Volume 1.
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, which is 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 or select a recently used ODBC data source from a list.
Open the ODBC Data Source Administrator button – Open the ODBC Administrator window, where you can select an ODBC data source from the list of available data sources. You may also choose to create a new data source or configure an existing data source to use for the connection.
Tip
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 window.
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 this Connect window.
Any information you enter in the Connect window, 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 or selecting a recently used ODBC data source file from a list. The ODBC data source file is often used for UNIX systems.
