SQLDriverConnect - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

ODBC Driver for Teradata
Release Number
August 2020
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

SQLDriverConnect allows the ODBC driver 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.

To change the value of an existing parameter or to enter a new value, the user clicks on the Change button, which is located on the Teradata Database Connect dialog box next to the Parameter field. A new Parameter dialog box displays, allowing the user to specify a new Parameter value. If a value already exists, it will be displayed in clear text and the user can edit or replace it. When changes are made, click the OK button.

The following example illustrates this.