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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database connections » ODBC data sources

Creating an ODBC data source on Mac OS X

Create an ODBC data source using the ODBC Administrator Tool.


Your Mac OS X system must not be version 10.6 or later.

The SQL Anywhere ODBC driver must be installed.

The ODBC Administrator Tool for Mac OS X must be installed. This tool is available from Apple.

The ODBC Administrator Tool for Mac OS X must be configured to use the SQL Anywhere ODBC driver first. Once this is done, then you may create data sources that use this driver.


Use of the ODBC Administrator Tool requires that either the ODBCINI or ODBC_INI environment variable be used to specify the non-standard location and file name of the ODBC initialization file (~/Library/ODBC/odbc.ini).

To avoid this issue, you can use the Data Source utility (dbdsn) to create ODBC data sources on Mac OS X.


  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 17.
  4. Click OK.
  5. In the Data Source Name field, type a name for your data source.
  6. In the Description field, type a suitable description for your data source.
  7. Specify valid connection parameters and values. Some values may be case insensitive. The following is an example.
    Keyword Value
    DatabaseFile /Applications/SQLAnywhere17/samples/demo.db
    StartLine dbeng17
    ServerName demo17
    ThreadManager ON

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

  8. Click OK.
  9. Click Apply.
  10. Press Command+Q to exit.


The ODBC data source is created.