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 » ODBC data sources

 

Creating an ODBC data source (Mac OS X)

You can create an ODBC data source using the ODBC Administrator Tool for Mac OS X.

Prerequisites

The ODBC Administrator Tool for Mac OS X and the SQL Anywhere ODBC driver must be installed.

Context and remarks

You can also use the Data Source utility (dbdsn) to create ODBC data sources on Mac OS X.

 Task

  1. Launch the ODBC Administrator Tool for Mac OS X from /Applications/Utilities.

  2. Click the User DSN tab, and then click Add.

  3. In the Name list, click SQL Anywhere 16.

  4. Click OK.

  5. In the Data Source Name field, type a name for your data source.

  6. Add the following connection parameters. The connection parameters and values are case insensitive.

    Keyword Value
    UserID DBA
    Password sql
    StartLine dbeng16
    ServerName demo16
    ThreadManager ON
    Driver SQL Anywhere 16
    Caution

    Storing user IDs, encrypted or unencrypted passwords, and database keys in a data source is not recommended.

  7. Click OK.

  8. Click Apply.

  9. Press Command+Q to exit.

Results

The ODBC data source is created.

 See also

Adding the SQL Anywhere ODBC driver (Mac OS X)

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