Examples - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

For a connect function call containing the Teradata Wallet reference string:

  • SQLConnect(hdbc, "mydsn", SQL_NTS, "myuid", SQL_NTS,"$tdwallet(RefString)", SQL_NTS);
  • SQLDriverConnect(hdbc, NULL, "DSN=mydsn;UID=myid;PWD=$tdwallet(RefString);", SQL_NTS, szConnStrout, cbConnStrOutMax, &cbConnectStrOutLen, NULL);
  • SQLDriverConnect(hdbc, NULL, "DRIVER={Teradata}; DBCNAME=platinum; AUTHENTICATION=LDAP;AUTHENTICATIONPARAMETER=authcid=$tdwallet(RefString1) password=$tdwallet(RefString2); ", SQL_NTS, szConnStrout, cbConnStrOutMax, &cbConnectStrOutLen, NULL);