15.10 - ODBC Options Section - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

ODBC Driver for Teradata
User Guide

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.

Table 20 lists applicable keywords under the [ODBC] section.

See Appendix D for examples of ODBC options files.


Table 20: ODBC Options Section Keywords 




Note: 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.ini file.

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>

    Note: TraceDLL is the keyword for DataDirect DM on UNIX/Linux. It is not applicable on Apple OS X.

    Specifies the path of the trace DLL, which is located in the Driver Manger library:

  • IBM AIX, Linux, HP-UX Itanium, and Solaris (default):
  • <InstallDir>/lib/odbctrac.so
  • HP-UX PA RISC (default):
  • <InstallDir>/lib/odbctrac.sl


    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