ODBC Options Section - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-18
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
ktb1507075385726
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.

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