Trafodion odbc driver安装配置（Linux）

一、下载

下载trafodion-client包：http://mirror.bit.edu.cn/apache/incubator/trafodion/apache-trafodion-2.1.0-incubating/bin/apache-trafodion_clients-2.1.0-RH6-x86_64-incubating.tar.gz

二、解压安装

#tar -zxvf apache-trafodion_clients-2.1.0-RH6-x86_64-incubating.tar.gz

#cd clients

#tar -zxvf TRAF_ODBC_Linux_Driver_64.tar.gz

#cd PkgTmp

#sudo ./install.sh

三、配置trafodion odbc

#vi /root/odb/uodbc/etc/odbc.ini
-----------------------
[traf]
Description = traf inst
Driver = Trafodion
Catalog = TRAFODION
Schema = QA
DataLang = 0
FetchBufferSize = SYSTEM_DEFAULT
Server = TCP:192.168.1.118:23400
SQL_ATTR_CONNECTION_TIMEOUT = SYSTEM_DEFAULT
SQL_LOGIN_TIMEOUT = SYSTEM_DEFAULT
SQL_QUERY_TIMEOUT = NO_TIMEOUT
ServiceName = HP_DEFAULT_SERVICE
#CLIENT_CHARSET = UTF8
ClientCharSet = UTF8

[ODBC]
traceFlags = ERROR
TraceStart = 0
TraceFile = tracefile.log
MaxTraceFileSize = 1024
AppUnicodeType=utf16
-----------------------

#vi /root/odb/uodbc/etc/odbcinst.ini
-----------------------
[Trafodion]
Description = Trafodion ODBC Stand Alone Driver
Driver = /usr/lib64/libtrafodbc_drvr64.so
FileUsage = 1
UsageCount = 1
AppUnicodeType = utf8
Threading = 1
terminal_charset = utf8

[ODBC]
Threading = 1
Trace = Off
Tracefile = uodbc.trc
-----------------------

三、验证安装

能够登录trafodion即表示安装成功（保证用户名密码正确）。

isql traf test1 test2

test1为登录trafodion的用户名，test2为登录trafodion的密码。