Validating the ODBC Installation - Teradata Tools and Utilities

Teradata Tools and Utilities for Microsoft Windows Installation Guide

Product
Teradata Tools and Utilities
Release Number
15.10.04
Published
April 2018
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
PDF_Installation_Windows_1600.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2407
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 tool can be used to validate the installation of ODBC Driver for Teradata. It is located in the directory:

InstallDir\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 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.