DSN Settings for Third-Party Applications

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

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
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