17.20 - Verifying Connection to The Database - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

Verify the client system can connect over TCP/IP to the server. Use connection test program tdxodbc located in /Library/Application Support/teradata/client/<TTU version>/bin.

The sample test program can take the ODBC DSN name, database user-id, and password as input and establish a connection to the database. It can take basic SQL request input from the user, submit it to the database, and display the results. In addition to verifying connection to the database, tdxodbc can also determine whether or not ODBC Driver for Teradata has been loaded correctly and report if there are any missing, required libraries.

Use this command to see the usage syntax of the test program:

/Library/Application Support/teradata/client/<TTU version>/bin/tdxodbc -h