개요

Tibero 환경에서 unixODBC를 설치하고 ODBC Driver를 등록한 후 데이터베이스 연결을 설정하고 검증하는 방법을 설명합니다.

테스트 환경

• OS: Linux (x86_64)

• Tibero: Tibero 7.2.4

• unixODBC: 2.3.14

• Tibero Client 경로: /home/test7/tibero7/client

방법

unixODBC 다운로드

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

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

설치 확인:

$ODBC_HOME/bin/isql --version
unixODBC 2.3.14

환경 변수 설정 (~/.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

적용 및 확인:

source ~/.bash_profile

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

Tibero ODBC Driver 등록 (odbcinst.ini)

경로:

$ODBC_HOME/etc/odbcinst.ini

내용:

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

확인:

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

Data Source 설정 (odbc.ini)

경로:

$ODBC_HOME/etc/odbc.ini

내용:

[TIBERO7]
Description = Tibero7 ODBC Test
Driver      = Tibero -- odbcinst.ini의 Driver 섹션명과 반드시 동일해야 함 
ServerName  = 127.0.0.1
Port        = 5555
SID         = test7
User        = tibero
Password    = tmax

확인:

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

연결 테스트 (isql)

$ODBC_HOME/bin/isql -v TIBERO7 tibero tmax

정상 결과:

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

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