ODBC provides a method for specifying connection information via a connection string and the SQLDriverConnect API. This section provides examples of connection strings configured to use common features and functionality. You can modify and/or combine these examples to create a connection string for your environment.

In addition to the connection strings for DSN-less connections demonstrated in this section, the driver supports DSN and File DSN connection strings. See "Using a connection string" for syntax and detailed information for supported connection string types.

Note: The options and values described in this section apply to all configuration methods.

Teradata 1/Teradata 2 authentication

This string includes the options used to connect with Teradata (TD1 or TD2) user ID and password authentication.

DRIVER=DataDirect 8.0 Teradata;DBCName=MyServer;PortNumber=1025;
       Database=DBTEST;UserID=jsmith;Password=secret;

For more information on these options and values, see Teradata 1 and Teradata 2 authentication.