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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » SQL Anywhere database connections » ODBC data sources


Creating an ODBC data source (Mac OS X)

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


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

    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.


The ODBC data source is created.



 See also

Adding the SQL Anywhere ODBC driver (Mac OS x)