ODBC Driver for Teradata has specific application uses defined for available DSN settings. The following table lists the DSN settings and their specific application use.
| ODBC.INI Setting Name | Name in DSN Setup Dialog | Specific Application Use |
|---|---|---|
| AccountStr=<account> Or Account=<account> |
Account String | – |
| CharacterSet=<charset name> Or CharSet=<charset name> |
Session Character Set | – |
| DateTimeFormat=[A|I]AA | DateTime Format | |
| DefaultDatabase=<database-name> Or Database=<database-name> |
Default Database | – |
| DontUseHelpDatabase=[Yes|No] Or DontUseHelpDB=[Yes|No] |
No HELP DATABASE | – |
| EnableExtendedStmtInfo=[Yes|No] | Enable Extended Statement Information | – |
| EnableReadAhead=[Yes|No] | Enable read-ahead | – |
| EnableReconnect=[Yes|No] | Enable Reconnect | – |
| EnableRedrive=[Yes|No|Default] | EnableRedrive | Determines whether requests on the session participate in Redrive, or not, or use the database-side default value. Default value is "Default". |
| EnableUDFUpload=[Yes|No] | Enable Client Side UDF Upload | – |
| IANAAppCodePage=<ODBC application code page> | – | This is set for application-specific code page number when using Unicode |
| IgnoreODBCSearchPattern=[Yes|No] Or IgnoreSearchPat=[Yes|No] |
Ignore Search Patterns | – |
|
IntegratedSecurity=[Yes|No] Or UseIntegratedSecurity=[Yes|No] |
Use Integrated Security | – |
| – | Log Error Events | – |
| LoginTimeout=<integer0> | Login Timeout | Increase the default 20 seconds to higher value for troubleshooting purposes only. This is a temporary workaround. |
| MaxRespSize=<integer=<16775168> | Maximum Response Buffer Size | The default is 64K; for large result sets, this value can be increased up to 16 MB. |
| MechanismName=<MechanismName> Or Authentication=<MechanismName> |
Mechanism | – |
| MechanismKey=<Value> Or AuthenticationParameter=<Value> |
Parameter | – |
| NoScan=[Yes|No] | Disable Parsing | – |
| OutputAsResultSet=[Yes|No] | Return Output Parameters As ResultSet | – |
| PrintOption=[N|P] | ProcedureWithPrintStmt | – |
| ReconnectCount=<value> | ReconnectCount | The maximum number of times the driver should attempt to reconnect to the database (0-99). Default is 20. |
| ReconnectInterval=<value> | ReconnectInterval | The number of seconds (1-300) between reconnect attempts. Default is 30. |
| retryOnEINTR | Retry system calls (EINTR) | KXEN |
| – | Return Empty string in CREATE_PARAMS columns for SQL_TIMESTAMP | MS Access |
| ReturnGeneratedKeys=<value> | Return Generated Keys | – |
| – | Return max. CHAR/VARCHAR length as 32K | MS Access |
| SessionMode=[Teradata|ANSI] | Session Mode | Set to ANSI to resolve application getting too many end transaction messages. |
| Sessions=<value> | Sessions | The number of FastExport data connections that the driver opens, to enable performance improvements for SELECT queries that meet the criteria of the FastExport protocol. The number of AMPs (Access Module Processors) that are available for your database determines the maximum number of FastExport data connections that can be opened. If you set this property to a number that is greater than the number of AMPs, the driver only opens a number of connections equal to the number of AMPs.
It is not recommended that you set this property. When this property is not set, the number of FastExport connections is determined automatically based on the database settings.
|
| SplOption=[Yes|No] | ProcedureWithSPLSource | – |
| TCPNoDelay=[Yes|No] | Use TCP_NODELAY | – |
| Translation DLL=<path> | Translation DLL Name | – |
| Translation Option=<option> | Translation Option | – |
| TDMSTPortNumber=<integer> | TDMST Port Number | Set to another port number if port 1025 is already used. By default, the Teradata Gateway is listening to port 1025. |
| Type=[Default|FastExport\ | Type | This option specifies whether the driver uses the FastExport protocol to improve the performance of SELECT queries that meet certain criteria.
|
| UDFUploadPath=<path> | UDF Upload Path | – |
| USE2XAPPCUSTOMCATALOGMODE=[Yes|No] Or 2XAPPCUSTOMCATALOGMODE=[Yes|No] |
Enable Custom Catalog Mode for 2.x Applications | MS Excel Importing data into an Excel 2000 spreadsheet by SQL query (using Data>>Get External Data>>New Database Query) |
| UseColumnNames=[Yes|No] Or DontUseTitles=[Yes|No] |
Use Column Names | Crystal Reports |
| UseDataEncryption=[Yes|No] Or DataEncryption=[Yes|No] |
Enable Data Encryption | – |
| – | Use DATE data for TIMESTAMP parameters | MS Access and other applications that are using Microsoft Access Jet databases |
| – | Use NULL for Catalog Name | – |
| – | Use Regional Settings for Decimal Symbol | – |
| UseXViews=[Yes|No] | Use X Views | – |