ODBC Options Section - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

ODBC Driver for Teradata
Release Number
August 2020
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

The ODBC Options section [ODBC] of the ini file specifies whether the ODBC driver manager options, such as tracing, are enabled or not. This format of this section is:


On UNIX/Linux, DataDirect ODBC DM finds the location of its supporting libraries and message files using the path value of the InstallDir keyword under this section. On UNIX/Linux, for DataDirect ODBC DriverManager, InstallDir is needed at a minimum under the [ODBC] section.

The following table lists applicable keywords under the [ODBC] section.

Keyword Description
InstallDir is applicable only on UNIX/Linux for DataDirect DriverManager.

Specifies the installation directory for ODBC Driver for Teradata.

An example default installation directory is/opt/teradata/client/ODBC_64.

A common error encountered while running an application is the inability to load ODBC Driver for Teradata. The cause is usually the fact that the exact location of ODBC Driver for Teradata has not been specified in the odbc.inifile.

The odbc.ini file must reference the exact location of ODBC Driver for Teradata.

Trace=[0] or [1] Enables Driver Manager tracing.
  • 0 (default) - disabled
  • 1 - enabled
TraceDll=<tracedll pathname>
TraceDLL is the keyword for DataDirect DM on UNIX/Linux. It is not applicable on Apple macOS.
Specifies the path of the trace DLL, which is located in the Driver Manger library:
  • IBM AIX, Linux, and Solaris (default):


TraceFile=<filepath> Specifies the path of the file where trace information is logged.
TraceAutoStop=[0] or [1] Disables tracing when SQLFreehandle for ENV is called.
  • 0 (default) - disabled
  • 1 - enabled