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

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


Connect window: Connect to a generic ODBC database

  • Change database type   If present, click to connect to a SQL Anywhere, a Sybase IQ, or an UltraLite database.

  • The following values are used to identify you to the 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.

    • Password   Type a password for the connection. The password must be the correct password for the user ID you supply.


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 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 (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. 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 ODBC data sources.

  • 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 (FILEDSN) connection parameter.

 See also