Validating the ODBC Installation - Teradata Tools and Utilities

Teradata Tools and Utilities for IBM s390x Linux Installation Guide

Product
Teradata Tools and Utilities
Release Number
15.10
Published
July 2017
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
PDF_Installation_Linux_s390x_1600.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-3123
Product Category
Teradata Tools and Utilities
Refer to ODBC Driver for Teradata User Guide, B035-2509 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:

InstallDir/teradata/client/TTUversion/bin

The tdxodbc tool can be used to validate the installation of ODBC Driver for Teradata. It is located in the directory:

/Library/Application Support/Teradata/client/TTUversion/bin

  1. Export the ODBCINI environment variable.

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

    where
    • InstallDir – Base installation directory, which is usually /opt.
    • ODBCODBC_32 for 32-bit or ODBC_64 for 64-bit.

    export ODBCINI='Library/Application Support/Teradata/client/odbc/odbc.ini'

  2. Run the command:

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

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

    where
    • 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.