Validating the ODBC Installation - Teradata Tools and Utilities

Teradata® Tools and Utilities for Linux Installation Guide Amazon Linux 2, CentOS, OEL, RedHat, SLES, Ubuntu

Product
Teradata Tools and Utilities
Release Number
16.20
Published
November 2020
Language
English (United States)
Last Update
2020-11-19
dita:mapPath
del1512703274392.ditamap
dita:ditavalPath
linux_No_ie.ditaval
dita:id
B035-3160
lifecycle
previous
Product Category
Teradata Tools and Utilities
Refer to ODBC Driver for Teradata® User Guide (B035-2526) for detailed information on how to use ODBC.

The tdxodbc (32-bit) or tdxodbc64 (64-bit) tool can be used to validate the installation of ODBC Driver for Teradata. It is located in the directory:

prefix/teradata/client/version/bin

  1. Export the ODBCINI environment variable.

    export ODBCINI=prefix/teradata/client/ODBC/odbc.ini

    where
    • prefix – Base installation directory, which is usually /opt.
    • ODBC ODBC_32 for 32-bit or ODBC_64 for 64-bit.
  2. Run the command:

    Use tdxodbc for 32-bit and tdxodbc64 for 64-bit.

    tdxodbdc -c SQLDriverConnect -C "DRIVER={driverName};DBCName=databasename;UID=username;PWD=password;" -t

    where the following is true:
    • driverName – Name of the Driver currently installed. The driver name has the format "Teradata Database ODBC Driver XX.YY" where XX points to the Major version and YY points to the minor version. For example, if you have the ODBC 16.10 Driver installed. the driverName would be "Teradata Database ODBC Driver 16.10".
    • databasename – Name or IP address of the Teradata database
    • username – Database username
    • password – Database password
    If the ODBC Driver for Teradata is installed correctly, the tool displays information that it successfully connected to the database.