Title: How can I setup an ODBC data source for c-treeSQL on Linux?

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 unixodbc
Below we'll explain how to configure the c-tree ODBC driver and how to create and test a DSN on Linux.

Edit the file /etc/odbcinst.ini to define the driver, e.g.
    [ctreeDriver]
    Driver=/path/to/libctodbc.so
    Description=ODBC for ctreeSQL
    FileUsage=1
Note - The libctodbc.so library is installed along with c-tree in the "driver/sql.odbc" subfolder.

Now that you have a driver, edit the file /etc/odbc.ini to create a DSN bind to this driver, e.g.
    [ctreeDSN]
    Driver=ctreeDriver
    Host=localhost
    Database=ctreeSQL
    Service=6597
    Description=ctreeSQL data source
To 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.ini 
You can test if your DSN is installed by executing:
    odbcinst -s -q
Expected result: [ctreeDSN] Please consider to set ODBCINI on environment variables, e.g.:
    export ODBCINI=/etc/odbc.ini
Now you can check if your unixODBC is configured for c-tree by running a tool connected to a unixODBC data source.
For example, you can execute the Interactive SQL (isql) from /usr/bin as shown below:
    isql ctreeDSN ADMIN ADMIN

Authored by: Veryant Support on Thu, Aug 8th, 2019 at 7:00 PM
This question has been viewed 1263 times so far.
Online URL: http://support.veryant.com/support/phpkb/question.php?ID=305

Powered by PHPKB Knowledge Base Software