DSN-Less Connection - 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

If you are using a DSN-Less connection, then you must use a driver name that exists in your odbcinst.ini file. If you are using release independent odbc.ini and odbcinst.ini files then the default driver name to use is Teradata. Otherwise, for 16.20 and beyond, if you are using release dependent odbc.ini and odbcinst.ini files then the default driver name is Teradata Database ODBC Driver XX.YY where XX.YY is the version.

For example, ODBCINI=/opt/Teradata/client/17.20/odbc_32/odbc.ini then a successful connection would use a connection string like "DRIVER={Teradata Database ODBC Driver 17.20};DBCName=156.43.66.95;UID=username;PWD=password;".