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:
prefix\Teradata\Client\TTUversion\bin
-
Run the command:
tdxodbdc -c SQLDriverConnect -C "DRIVER={Teradata};DBCName=databasename;UID=username;PWD=password;" -t
whereIf the ODBC Driver for Teradata is installed correctly, the tool displays information that it successfully connected to the database.
- databasename – Name or IP address of the Teradata database.
- username – Database username.
- password – Database password.