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

Configure the ODBC Administrator Tool for Mac OS X

Add the SQL Anywhere ODBC driver to the ODBC Administrator Tool for Mac OS X so that you can create an ODBC data source that uses this driver.

Prerequisites

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.

Context

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

Procedure

  1. Launch the ODBC Administrator Tool for Mac OS X from /Applications/Utilities.
  2. Click the Drivers tab.
  3. Click Add.
  4. In the Description field, type SQL Anywhere 17.
  5. Click Choose and select the SQL Anywhere ODBC driver in both the Driver File Name and Setup File Name fields. By default, it is located in /Applications/SQLAnywhere17/System/lib64/dbodbc17_r.bundle.

    The _r in the bundle name indicates that it is the threaded version of the driver. There is also an unthreaded version (dbodbc17.bundle) for use with unthreaded applications.

  6. Click OK.

    The ODBC configuration files are located in /Library/ODBC within your home directory. There is an odbcinst.ini file for driver information and an odbc.ini file for data source information. You can edit the information with a text editor.

    You must use either the ODBCINI or ODBC_INI environment variable to specify the non-standard location and file name of the ODBC initialization file (~/Library/ODBC/odbc.ini).

Results

The SQL Anywhere ODBC driver is added.