Using an ODBC driver manager on Unix

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