SQL Anywhere Studio Help
Connect Dialog Help
The Identification tab of the Connect dialog has the following components:
User ID Type a user ID for the connection. For the sample database (asademo), the user ID is DBA. The user ID you supply must have permissions on a database in order to connect.
Password Type a password for the connection. For the sample database (asademo), the password is SQL. The password must be the correct password for the user ID you supply.
Extended characters used in passwords are case-sensitive, regardless of the database sensitivity setting.
For more information about passwords and case sensitivity, see Initialization utility options.
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.
For information about the DSN connection parameter, see DataSourceName connection parameter [DSN].
ODBC Administrator button Click the ODBC Administrator button to open the ODBC Administrator dialog where you can select an ODBC data source from the list of available data sources. If you want to select a data source, select it from the list and then click OK.
You may also choose to create a new data source or configure an existing data source to use for the connection.
For information about using the ODBC Administrator dialog, see Working with ODBC data sources.
TipODBC 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. |
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.
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.
TroubleshootingIf you use an ODBC data source and fail to connect, test your data source.To test an ODBC data source, open the ODBC Data Source Administrator dialog (from the Start menu, choose Programs On the User DSN tab of the ODBC Data Source Administrator dialog, select an ODBC data source from the list and click Configure. This opens the ODBC Configuration for Adaptive Server Anywhere dialog. On the ODBC tab of the ODBC Configuration for Adaptive Server Anywhere dialog, click Test Connection. A dialog appears telling you whether or not the connection succeeds. |
For more information about ODBC data sources, see Working with ODBC data sources.
Troubleshooting server startup
Troubleshooting network communications