When SQL Optimizer starts, a User Logon dialog field displays for you to connect to the Adaptive Server database.
| Item | Description |
| Login name | Enter the login name required to connect to the database. |
|
Password |
Enter the password associated with the login name. |
|
Server name |
Enter the Adaptive Server name as defined in the client configuration. |
The Server list contains the database servers taken from the SQL.INI file.
| Item | Description |
| Host name | Enter the name of the computer where the database resides. |
|
Port number |
Enter the port number that was assigned to Adaptive Server. |
After selecting and entering the connection information, click Connect.
The Loading Data Dictionary window may be shown while connecting to the database to indicate that information from the data dictionary is being retrieved and loaded in the memory of the computer. This information is used when the SQL statement is parsed for functions such as scanning, optimization, and index generation. Depending on the number of objects in your database, the loading of all the information from the data dictionary may take considerable time. Therefore you may want to use the option in the General Preferences with does not load the data dictionary when the connection to the database is made, but does load the specific information that is needed when SQL statements are parsed. This saves time when the connection is made and adds a little more time to the parsing process.
Note: The first time the program is launched, the Language dialog field displays a list of available interface and character set languages. The character set allows you to view data in the chosen language.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
