Using the SQL Anywhere ODBC driver manager on Unix

SQL Anywhere includes an ODBC driver manager for Unix. The libdbodm12 shared object can be used on all supported Unix platforms as an ODBC driver manager. The iAnywhere ODBC driver manager can be used to load any version 3.0 or later ODBC driver. The driver manager will not perform mappings between ODBC 1.0/2.0 calls and ODBC 3.x calls; therefore, applications using the iAnywhere ODBC driver manager must restrict their use of the ODBC feature set to version 3.0 and later. Also, the iAnywhere ODBC driver manager can be used by both threaded and non-threaded applications.

The iAnywhere ODBC driver manager can perform tracing of ODBC calls for any given connection. To turn on tracing, a user can use the TraceLevel and TraceLog directives. These directives can be part of a connection string (in the case where SQLDriverConnect is being used) or within a DSN entry. The TraceLog is a log file where the traced output for the connection goes while the TraceLevel is the amount of tracing information wanted. The trace levels are:

NONE No tracing information is printed.
MINIMAL Routine name and parameters are included in the output.
LOW In addition to the above, return values are included in the output.
MEDIUM In addition to the above, the date and time of execution are included in the output.
HIGH In addition to the above, parameter types are included in the output.

Also, third-party ODBC driver managers for Unix are available. Consult the documentation that accompanies these driver managers for information about their use.

Discuss this page in DocCommentXchange.