Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database connections

 

Connecting using an ODBC data source (administration tools)

To connect to a database using an ODBC data source, use the Connect window with the ODBC Data Source name option.

Prerequisites

An ODBC data source for the database that you want to connect to.

The SQL Anywhere 16 Demo data source is configured to start the database server and database if they are not already running. If your ODBC data source is not configured to start the database and database server, then you must start them. For example, run the following command to start the sample database: 

dbsrv16 -n demo16 "%SQLANYSAMP16%\demo.db;"
 Task

  1. Open the Connect window from an administration tools, such as Interactive SQL.

  2. Complete the following fields to connect to the database:

    1. In the Authentication dropdown list, click Database.

    2. In the User ID field, type a user name. For example, type DBA.

    3. In the Password field, type a password for the user. For example, type sql.

    4. In the Action dropdown list, click Connect with an ODBC Data Source.

    5. Do one of the following:

      • Click ODBC Data Source name and type the name of the data source. For example, type SQL Anywhere 16 Demo.

      • Click ODBC Data Source file and type the FileDataSourceName (FILEDSN) connection parameter that references a data source held in a file.

  3. (Optional) To get a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.

  4. Click Connect.

Results

The administration tool connects to the database.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0