Question ID : 305
Created on 2019-08-08 at 10:06 AM
Author : Veryant Support [email@example.com]
Online URL : http://support.veryant.com/support/phpkb/question.php?ID=305
The unixODBC software allows to create ODBC data sources on Linux.
This software may not be installed on your system. Use a command like this to install it:
sudo apt install unixodbcBelow we'll explain how to configure the c-tree ODBC driver and how to create and test a DSN on Linux.
[ctreeDriver] Driver=/path/to/libctodbc.so Description=ODBC for ctreeSQL FileUsage=1Note - The libctodbc.so library is installed along with c-tree in the "driver/sql.odbc" subfolder.
[ctreeDSN] Driver=ctreeDriver Host=localhost Database=ctreeSQL Service=6597 Description=ctreeSQL data sourceTo allow the unixODBC install the odbcinst and odcini you must execute the following commands:
odbcinst -i -d -f /etc/odbcinst.ini odbcinst -i -s -l -f /etc/odbc.iniYou can test if your DSN is installed by executing:
odbcinst -s -qExpected result: [ctreeDSN] Please consider to set ODBCINI on environment variables, e.g.:
export ODBCINI=/etc/odbc.iniNow you can check if your unixODBC is configured for c-tree by running a tool connected to a unixODBC data source.
isql ctreeDSN ADMIN ADMIN
Back to Original Question