Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Context-Sensitive Help » Connect window help

 

Connect window: Identification tab (MobiLink and QAnywhere)

This tab has the following components:

User ID   Type a user ID for the database connection. The user ID you supply must have permissions on a database to connect. See Userid connection parameter [UID].

Password   Type a password for the connection. This must be the correct password for the user ID you supply. Passwords are case sensitive. See Password connection parameter [PWD].

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. See DataSourceName connection parameter [DSN].

  • Open the ODBC Data Source Administrator button   Click the Open the ODBC Data Source Administrator button to open the ODBC Administrator window 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. See Creating ODBC data sources.

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 this 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. 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 connection parameter [FILEDSN].

Connection type   Choose Generic ODBC Database from the list when connecting to a database other than SQL Anywhere or UltraLite (for example, Microsoft SQL Server, DB2, or Oracle).

Tools   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.

    Click Show Details to see debugging information about how the connection parameters are used to find the database server.

  • 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 ActiveSync installed and are connecting to a SQL Anywhere or UltraLite database.

  • Save as ODBC Data Source   This tool creates an ODBC data source based on the information provided. See Create ODBC data sources using the Connect window.

  • Copy Connection String to Clipboard   This tool copies the connection string, which is based on the information provided in the Connect window, into the clipboard.