Skip to main content

Search

Welcome to Tibero GTS!

How to Configure ODBC (Linux)

Document Type | Technical Information

Category | Interface/Integration

Applicable Product Version | 7FS02PS04

Document Number | TIITI060

 

Overview

This explains how to configure the Tibero ODBC environment in Linux/Unix environments.

Since Linux/Unix-based operating systems often do not have an ODBC Driver Manager installed by default, unixODBC must be installed separately, environment variables must be set, and then the Tibero ODBC Driver must be integrated.

This guide is based on an environment where Tibero is not installed, and describes using unixODBC as the ODBC Driver Manager.

 
 

Method

Install ODBC Driver Manager

  • Download the unixODBC source

  • configure → make → make install installation sequence

  • Configure environment based on the installation prefix path

 

Set Environment Variables

The following environment variables must be set.

UNIXODBC_HOME
LD_LIBRARY_PATH
PATH
ODBCINI
ODBCSYSINI

  • ODBCINI : Specifies the odbc.ini file to use

  • ODBCSYSINI : Specifies the location of odbcinst.ini

If these environment variables are not set, Data Source recognition errors may occur.

 

Register Tibero ODBC Driver

  • Copy the $TB_HOME/client/lib/libtbodbc.so file

  • Grant execution permissions

  • Register the absolute path of the Driver in odbcinst.ini

 

Data Source Configuration

Define the following items in the odbc.ini file.

Driver
SERVER
PORT
DATABASE
USER
PASSWORD

※ SERVER, PORT, and DATABASE must be set as a complete set.

 

Verify Configuration

Check the configuration status with the following commands.

odbcinst -j
odbcinst -q -d
odbcinst -q -s

 

Connection Test

isql <DSN name>

If connected successfully, the message “Connected!” will be displayed.

 

Additional Checks

  • Check for mixing of 32bit/64bit libraries

  • Check for existence of multiple odbc.ini files

  • Verify Driver path and permissions

 

Note

When installing unixODBC on 64bit environments (such as AIX), setting OBJECT_MODE=64 may be necessary.

It is recommended to explicitly set the ODBCINI and ODBCSYSINI environment variables.

tbCLI operates based on the ODBC 3.x standard and can reference connection information via ODBC settings or the tbdsn.tbr file.

 

Caution

Connection errors occur if there are typos in the Driver path or if permissions are not set.

If any of SERVER, PORT, or DATABASE is missing, connection will fail.

If multiple odbc.ini files exist, an unexpected file may be referenced, so be sure to specify the ODBCINI environment variable.

Mixing 32bit and 64bit libraries may cause connection errors.

 

 

 

Related to