ODBC Options Section - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2526
lifecycle
previous
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:

[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.

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

See Appendix D for examples of ODBC options files.

 

Table 20: ODBC Options Section Keywords 

Keyword

Description

InstallDir=<filepath>

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

    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