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 |
|---|---|---|
| AccountString=<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 | – |
| 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 | – |
| 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. |
| 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. |
| 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 | – |