The SQL Anywhere ODBC driver must be added before you create the ODBC data source.
Storing user IDs, encrypted or unencrypted passwords, and database keys in a data source is not recommended.
Launch the ODBC Administrator from /Applications/Utilities.
Select the Drivers tab.
Click Add.
In the Description field, type SQL Anywhere 11.
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/SQLAnywhere11/System/lib/dbodbc11_r.bundle.
The _r in the bundle name indicates that it is the threaded version of the driver. There is also an unthreaded version (dbodbc11.bundle) for use with unthreaded applications.
Click OK.
You can add the information with a text editor. 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 also use the Data Source utility (dbdsn) to create ODBC data sources on Mac OS X. See Data Source utility (dbdsn).
Launch the ODBC Administrator from /Applications/Utilities.
In the ODBC Administrator, click the User DSN tab, and then click Add.
In the Name list, click SQL Anywhere 11.
Click Finish.
In the Data Source Name field, type Demo11.
Add the following connection parameters. The connection parameters and values are case insensitive.
Keyword | Value |
---|---|
User ID | DBA |
Password | sql |
Start Line | dbeng11 |
Database File | /Applications/SQLAnywhere11/System/demo.db |
ThreadManager | ON |
Driver | SQL Anywhere 11 |
For more information about connection parameters, see Connection parameters and network protocol options.
Click OK.
Click Apply.
Press Command+Q to exit the ODBC Administrator.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |