Verifying Connection to The Database - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-18
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
ktb1507075385726
Product Category
Teradata Tools and Utilities

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