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.