SQL Anywhere includes an ODBC driver manager for Unix. The libdbodm10 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 above 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 above. 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 desired. 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 on their use.