Validating the ODBC Installation - Teradata Tools and Utilities

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

Deployment
VantageCloud
deployment
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Tools and Utilities
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
trg1641290463177.ditamap
dita:ditavalPath
bbv1473194095470.ditaval
dita:id
ems1473187628189
Product Category
Teradata Tools and Utilities
See the ODBC Driver for Teradata® User Guide, B035-2526 for detailed information on how to use ODBC.

Use the tdxodbc (32-bit) or tdxodbc64 (64-bit) tool to validate the installation of ODBC Driver for Teradata. It is located in the prefix/teradata/client/version/bin directory.

  1. Export the ODBCINI environment variable.

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

    where the following is true:
    • prefix is the Base installation directory, which is usually /opt.
    • ODBCODBC_32 for 32-bit or ODBC_64 for 64-bit.
  2. Run the command to initiate the tool:

    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 is the 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 17.20 Driver installed. the driverName would be "Teradata Database ODBC Driver 17.20".
    • databasename is the name or IP address of the Vantage system.
    • username is the Database username
    • password is the Database password
    If the ODBC Driver for Teradata is installed correctly, the tool displays information that it successfully connected to the database.