Validating the ODBC Installation - Teradata Tools and Utilities

Teradata® Tools and Utilities for Microsoft Windows Installation Guide

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-11-20
dita:mapPath
ofn1544831946734.ditamap
dita:ditavalPath
dpj1465132351025.ditaval
dita:id
B035-2407
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 tool can be used to validate the installation of ODBC Driver for Teradata. It is located in the directory:

prefix\Teradata\Client\TTUversion\bin

  • Run the command:
    tdxodbdc -c SQLDriverConnect -C "DRIVER={Teradata};DBCName=databasename;UID=username;PWD=password;" -t
    where
    • databasename – Name or IP address of the database.
    • username – Database username.
    • password – Database password.
    If ODBC Driver for Teradata is installed correctly, the tool displays information that it successfully connected to the database.