Connecting using an ODBC data source (Sybase Central or Interactive SQL)

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.

Context and remarks

The SQL Anywhere 12 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 SQL Anywhere 12 sample database: 

dbeng12 -n demo12 "%SQLANYSAMP12%\demo.db"
 Connecting with an ODBC data source (Sybase Central or Interactive SQL)

  1. Open the Connect window from Sybase Central or Interactive SQL. See Opening the Connect window (Sybase Central).

  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 Using 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 12 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.

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1