Validating the ODBC Installation - Teradata Tools and Utilities

Teradata Tools and Utilities for HP-UX Installation Guide
Product
Teradata Tools and Utilities
Release Number
15.10
Published
August 2016
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
PDF_Installation_UNIX_HP_UX_1600.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-3124
lifecycle
previous
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.
    • ODBC – ODBC_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.