ODBC Options Section

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

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:

[ODBC]
keyword=value

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=<filepath>
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 OS X.
Specifies the path of the trace DLL, which is located in the Driver Manger library:
  • IBM AIX, Linux, and Solaris (default):

    <InstallDir>/lib/odbctrac.so

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