문서유형ㅣ기술정보
분야ㅣ인터페이스/연동
적용제품버전ㅣTibero6, Tibero7
문서번호ㅣTIITI063
개요
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