If present, click to connect to a Sybase IQ database, an UltraLite database, or a generic ODBC database.
Choose one of the following options to connect to the SQL Anywhere database:
Database Connect to the database using a user ID and password.
User ID Type a user ID for the connection. The user ID you supply must have permissions on a database to connect. See Userid (UID) connection parameter.
The default user ID for SQL Anywhere databases is DBA.
Password Type a password for the connection. The password must be the correct password for the user ID you supply. Passwords are case sensitive. See Password (PWD) connection parameter.
The default password for SQL Anywhere databases is sql when you connect with the default user, DBA.
Windows Integrated Login Choose this option to connect to the database using an integrated login on Microsoft Windows. When you choose this option, 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. See Windows integrated logins.
Use the action Connect with an ODBC data source when you want to connect to a database using an ODBC data source.
When this action is chosen, the following options are available:
Any information you enter in this Connect window, such as the user ID or password, is used instead of the parameters stored in an ODBC data source or an ODBC data source file.
ODBC Data Source name Select this option and type the ODBC data source name to connect to the database. You can also choose a recently-used ODBC data source from the dropdown list. On Windows, you can view a list of data sources by clicking Browse.
This field is equivalent to the DSN connection parameter, which references a data source in the registry. See DataSourceName (DSN) connection parameter.
Open The ODBC Data Source Administrator button Click the Open the ODBC Data Source Administrator button to open the ODBC Data Source Administrator window where you can select an ODBC data source from the list of available data sources, create a new data source, or configure an existing data source to use for the connection. See ODBC data sources.
ODBC Data Source file Select this option and type the ODBC data source file name for the connection. You can also choose a recently-used ODBC data source from the dropdown list. On Windows, you can search for the file by clicking Browse.
The ODBC data source file is often used for Unix systems. File data sources hold the same information as ODBC data sources stored in the registry. See FileDataSourceName (FILEDSN) connection parameter.
The following tools are available:
Test Connection This tool tests whether the information provided results in a proper connection. This tool is only available when you are connecting to a SQL Anywhere database.
Copy Connection String to Clipboard This tool copies the connection string, which is based on the information provided, to the clipboard.
Save as ODBC Data Source This tool creates an ODBC data source based on the information provided. See Creating an ODBC data source (Sybase Central and Interactive SQL).
Setup Windows Mobile proxy port This tool helps you set up a TCP/IP port redirector for connecting to Windows Mobile databases (if Windows Mobile services are installed). This tool is only available if you have Microsoft ActiveSync installed and are connecting to a SQL Anywhere or UltraLite database.
If required, you can click Advanced to specify options such as TCP/IP, encryption, and other advanced options. See Connect window: Connect to a SQL Anywhere database:Advanced options tab and Connect window: Connect to a SQL Anywhere database: Network tab.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|