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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming » ODBC support » ODBC application development


The SQL Anywhere ODBC driver manager for Unix

SQL Anywhere includes an ODBC driver manager for Unix. The libdbodm16 shared object can be used on all supported Unix platforms as an ODBC driver manager. The 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 driver manager must restrict their use of the ODBC feature set to version 3.0 and later. Also, the driver manager can be used by both threaded and non-threaded applications.

The driver manager can perform tracing of ODBC calls for any given connection. To turn on tracing, 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 directive identifies the log file to contain the trace output for the connection. The TraceLevel directive governs 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.

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

 See also