17.20 - SQLDriverConnect - 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

SQLDriverConnect allows ODBC Driver for Teradata to define an arbitrary amount of connection information in the form of keyword-value pairs in the connection string. For example, a custom program that always uses the XYZ Corp data source might prompt the user for names and passwords and build the following set of keyword-value pairs, or connection string, to pass to SQLDriverConnect:

DSN=XYZ Corp;UID=Gomez;PWD=Sesame;

The SQLDriverConnect function is allowed to prompt the user for required logon information unless called with the SQL_DRIVER_NOPROMPT option.

Sometimes it might be necessary to supply additional information such as Profile=MyProfile to log on to the database. In this case, the additional information is contained in the Parameter field. The Parameter value was specified when the DSN was created. Like a password, the value will be masked.

The following example illustrates this.

completing connection information