Creating an ODBC data source (Mac OS X)

To create an ODBC data source on Mac OS X, use the ODBC Data Source Administrator.

Prerequisites

The SQL Anywhere ODBC driver must be installed before you create the ODBC data source. See Adding the SQL Anywhere ODBC driver (Mac OS x).

Context and remarks

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

 Creating an ODBC data source (Mac OS X)

  1. Launch the ODBC Data Source Administrator from /Applications/Utilities.

  2. In the ODBC Data Source Administrator, click the User DSN tab, and then click Add.

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

  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 dbeng12
    ServerName demo12
    ThreadManager ON
    Driver SQL Anywhere 12
    Caution

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

    For more information about connection parameters, see Connection parameters.

  7. Click OK.

  8. Click Apply.

  9. Press Command+Q to exit the ODBC Data Source Administrator.

Results

The ODBC data source is created.

Next

None.

 See also

Adding the SQL Anywhere ODBC driver (Mac OS x)

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