---

Easysoft ODBC-Sybase Driver User Guide - Technical Reference

Technical Reference for the Easysoft ODBC-Sybase Driver

This section contains extra information relating to the deployment of the Easysoft ODBC-Sybase Driver.

Appendix Guide

• Restrictions
• Supported API Calls
• Threading
• Tracing

Restrictions

The Easysoft ODBC-Sybase Driver lets you access Sybase ASE database versions 12.5.x and 15+.

Supported API Calls

All the ODBC 3.5 calls are supported except for the following:

• SQLBulkOperations
• SQLDescribeParam
• SQLCopyDesc
• SQLBrowseConnect

Threading

The Easysoft ODBC-Sybase Driver is thread safe in accordance with the ODBC 3.5 specification and can safely be used behind threaded applications.

Tracing

The ODBC calls an application makes can be traced:

• Within the Driver Manager by an application.
• From within the Driver Manager.
• From within the Easysoft ODBC-Sybase Driver.

Within the driver manager by an application

An application can turn tracing on in the Driver Manager by using the ODBC API SQLSetConnectAttr (...,SQL_ATTR_TRACE,...).

The trace filename may also be specified with the SQLSetConnectAttr attribute SQL_ATTR_TRACEFILE.

From within the driver manager

For the unixODBC Driver Manager, add two attributes to the [ODBC] section (create one if none exists) in odbcinst.ini.

Trace = Yes

TraceFile = /path/filename

For example:

[ODBC]

Trace = Yes

TraceFile = /tmp/sql.log

Ensure that the user who is running the application to be traced has write permission to TraceFile (and to the directory containing it), or no tracing information will be produced.

From within the Easysoft ODBC-Sybase Driver

Add a LOG attribute to the DSN section of the odbc.ini file.

For example:

[SYBASE]

....

LOG = /tmp/sybase.log

The LOG value is the path and file name of the log file, for example, /tmp/sybase.log.