Overview

This document explains how to install unixODBC in the Tibero environment, register the ODBC Driver, then configure and verify the database connection.

Test Environment

• OS: Linux (x86_64)

• Tibero: Tibero 7.2.4

• unixODBC: 2.3.14

• Tibero Client Path: /home/test7/tibero7/client

Method

Download unixODBC

wget https://www.unixodbc.org/unixODBC-2.3.14.tar.gz

Install unixODBC

cd /home/test7/unixodbc
tar -xzf unixODBC-2.3.14.tar.gz
cd unixODBC-2.3.14

./configure --prefix=/home/test7/unixodbc/install/unixODBC-2.3.14 --disable-gui

make
make install

Verify installation:

$ODBC_HOME/bin/isql --version
unixODBC 2.3.14

Set Environment Variables (~/.bash_profile)

# Tibero ENV
export TB_HOME=/home/test7/tibero7
export TB_SID=test7
export TB_PROF_DIR=$TB_HOME/bin/prof

# unixODBC ENV
export ODBC_HOME=/home/test7/unixodbc/install/unixODBC-2.3.14
export ODBCSYSINI=$ODBC_HOME/etc
export ODBCINI=$ODBC_HOME/etc/odbc.ini
export ODBCINSTINI=odbcinst.ini

# PATH / LIB
export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$ODBC_HOME/bin:$PATH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$ODBC_HOME/lib:/usr/lib64:$LD_LIBRARY_PATH

Apply and verify:

source ~/.bash_profile

env | egrep 'TB_HOME|ODBC_HOME|ODBCINI|ODBCINSTINI|ODBCSYSINI'

Register Tibero ODBC Driver (odbcinst.ini)

Path:

$ODBC_HOME/etc/odbcinst.ini

Content:

[Tibero]
Description = Tibero ODBC Driver
Driver      = /home/test7/tibero7/client/lib/libtbodbc.so
FileUsage   = 1

Verify:

$ODBC_HOME/bin/odbcinst -q -d
[Tibero]

ldd /home/test7/tibero7/client/lib/libtbodbc.so
        linux-vdso.so.1 (0x00007ffde1ff5000)
        libpthread.so.0 => /usr/lib64/libpthread.so.0 (0x00007fa0a4094000)
        libm.so.6 => /usr/lib64/libm.so.6 (0x00007fa0a3d12000)
        librt.so.1 => /usr/lib64/librt.so.1 (0x00007fa0a3b0a000)
        libc.so.6 => /usr/lib64/libc.so.6 (0x00007fa0a3733000)
        /lib64/ld-linux-x86-64.so.2 (0x00007fa0a5e11000)

Set Data Source (odbc.ini)

Path:

$ODBC_HOME/etc/odbc.ini

Content:

[TIBERO7]
Description = Tibero7 ODBC Test
Driver      = Tibero -- Must be exactly the same as the Driver section name in odbcinst.ini 
ServerName  = 127.0.0.1
Port        = 5555
SID         = test7
User        = tibero
Password    = tmax

Verify:

$ODBC_HOME/bin/odbcinst -q -s
[TIBERO7]

Connection Test (isql)

$ODBC_HOME/bin/isql -v TIBERO7 tibero tmax

Expected result:

+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| echo [string]                         |
| quit                                  |
|                                       |
+---------------------------------------+

SQL> select sysdate from dual;
+--------------------+
| SYSDATE            |
+--------------------+
| 2025/12/15         |
+--------------------+
SQLRowCount returns 1
1 rows fetched