Release-Independent 32-bit odbc.ini File | ODBC Driver for Teradata - Release-Independent 32-bit odbc.ini File Example - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-18
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
ktb1507075385726
Product Category
Teradata Tools and Utilities

The installation program creates the release-independent 32-bit odbc.ini file in /opt/teradata/client/ODBC_32.

[ODBC]
InstallDir=/opt/teradata/client/ODBC_32
Trace=0
TraceDll=/opt/teradata/client/ODBC_32/lib/odbctrac.so
TraceFile=/usr/joe/odbcusr/trace.log
TraceAutoStop=0

[ODBC Data Sources]
default=tdata.so
testdsn=tdata.so

[testdsn]
Driver=/opt/teradata/client/ODBC_32/lib/tdata.so
Description=Teradata running Teradata V1R5.2
DBCName=208.199.59.208
LastUser=
Username=
Password=
Database=
DefaultDatabase=

[default]
Driver=/opt/teradata/client/ODBC_32/lib/tdata.so
Description=Default DSN is Teradata 5100
DBCName=208.199.59.208
LastUser=
Username=
Password=
Database=
DefaultDatabase=
[ODBC]
# For Data Direct to load its error messages
# Data Direct Driver Manager looks for the messages here:
# "/opt/teradata/client/17.20/locale/xx_xx/LC_MESSAGES/"
InstallDir=/opt/teradata/client/17.20
Trace=no
Pooling=yes

[ODBC Data Sources]
Teradata ODBC DSN=Teradata Database ODBC Driver 17.20

[Teradata ODBC DSN]
# This key is not necessary and is only to give a description of the data source.
Description=Teradata Database ODBC Driver 17.20

# Driver: The location where the ODBC driver is installed to.
Driver=/opt/teradata/client/17.20/lib/tdataodbc_sb32.so

# Required: These values can also be specified in the connection string.
DBCName=
UID=


# Optional
AccountStr=
CharacterSet=ASCII
DatasourceDNSEntries=
DateTimeFormat=AAA
DefaultDatabase=
DontUseHelpDatabase=0
DontUseTitles=1
EnableExtendedStmtInfo=1
EnableReadAhead=1
IgnoreODBCSearchPattern=0
LogErrorEvents=0
LoginTimeout=60
MaxRespSize=65536
MaxSingleLOBBytes=4000
MaxTotalLOBBytesPerRow=65536
MechanismName=
NoScan=0
PrintOption=N
retryOnEINTR=1
ReturnGeneratedKeys=N
SessionMode=System Default
SplOption=Y
TABLEQUALIFIER=0
TCPNoDelay=1
TdmstPortNumber=1025
UPTMode=Not set
USE2XAPPCUSTOMCATALOGMODE=0
UseDataEncryption=0
UseDateDataForTimeStampParams=0
USEINTEGRATEDSECURITY=0
UseSequentialRetrievalOnly=0
UseXViews=0
EnableUDFUpload=0
UDFUploadPath=Please enter the UDF folder path 
EnableRedrive=Default
ReconnectCount=20
ReconnectInterval=30
Type=Default
HTTPS_PORT=443
SSLMode=Prefer
SSLProtocol=TLSv1.2
SSLCA=
SSLCAPath=
SSLCRC=Allow
SSLOCSP=ON
SSLCRL=ON
HTTP_PROXY=
HTTP_PROXY_USER=
HTTP_PROXY_PASSWORD=
HTTPS_PROXY=
HTTPS_PROXY_USER=
HTTPS_PROXY_PASSWORD=
ALL_PROXY=
ALL_PROXY_USER=
ALL_PROXY_PASSWORD=
PROXY_BYPASS_HOSTS=