|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.
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.
Edit the file /etc/odbcinst.ini to define the driver, e.g.
[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.
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 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.
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