Easysoft ODBC-Access Driver User's Guide - Technical Reference

Technical Reference for the Easysoft ODBC-Access Driver

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

Appendix Guide

ODBC Conformance

The Easysoft ODBC-Access Driver complies with the ODBC 3.51 specification.

The Easysoft ODBC-Access Driver is Level 1 compliant.

ODBC API Support

All ODBC 3.51 calls are fully supported apart from.

Supported Data Types

The Easysoft ODBC-Access Driver supports the following Access data types:

VARBINARY

BYTE

DATE

TIME

DOUBLE

INT

NUMERIC

DEC

LONGCHAR

MEMO

Threading

The Easysoft ODBC-Access Driver is thread safe in accordance with the ODBC 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

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

The trace file name 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 =logfile

For example:

[ODBC]

Trace = Yes

TraceFile = /tmp/unixodbc.log

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