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
- 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'
- 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
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