Each data source listed in the ODBC Data Sources section [<data-source-name>] of the odbc.ini file includes its own Data Source Specification section. These sections have the following format:
[<data-source-name>]
Driver=<driver-path>
Keyword=<attribute>
The lines following the data source name define the required and optional attributes.
Table 22 contains the available options that can be entered into the Data Source Specification section.
See Appendix D for examples of ODBC options files.
Keyword/Synonym |
Description |
||
Driver=<driver-path> |
[Required] The full path to the ODBC Driver for Teradata shared objects. |
||
Description=<data-source-desc> |
[Optional] Descriptive text about the data source. |
||
DBCName=<IP-addr-or-alias> |
[Required] The IP address or FQDN (fully qualified domain name) of the Teradata server. When a name is specified, ODBC Driver for Teradata automatically detects associated COP entries. For example, if the name contains a COPx suffix. For more information, see “Cop Discovery” on page 51. |
||
Username=<name> Or UID=<name> |
[Optional] The default username for logging onto a Teradata server system. |
||
Password=<password> |
[Optional] The password required for the default Username.
You can use a Teradata Wallet reference string instead of a plain text password by specifying the $tdwallet() token. For example: Password=$tdwallet(WalletRefString) For more information, see “Teradata Wallet” on page 98. |
||
DefaultDatabase=<database-name> Or Database=<database-name> |
[Optional] The default database associated with the specified data source. When no value is specified for this field, it is assigned the value of the user name as entered into the Username field. This field entry can be overridden when a new connection is specified. All catalog functions are associated with the default database if a table owner is not specified. |