You are here:

ODBC

How to Install ODBC on Linux

Step 1. Install ODBC:

On RHEL / CentOS:

yum install unixODBC unixODBC-devel
yum install postgresql-odbc

On Debian / Ubuntu:

apt-get update
apt-get install unixodbc unixodbc-dev odbc-postgresql

After installation, verify the driver version:

odbcinst -q -d

odbcinst -q -d -n PostgreSQL

Step 2. Create the odbc.ini file:

[accounts]
Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so
Database=accounts
Servername=postgres-db
Port=5432
UserName=postgres
Password=password

Step 3. Set environment variables for compilation and runtime:

export ODBCINI=/etc/odbc.ini
export LYCIA_DB_DRIVER=odbc

ODBC Client for Windows

ODBC Administrator tool on Windows can be used to establish connections to other database management systems that use SQL.

Individual connection profiles can be set up using the tabs in the ODBC Data Source Administrator window:

Press the Add… button and then enter the name of the data source and select the server, i.e. SQL Server. In the new dialog enter the DSN name and select the server to connect to:

The name of the data source entered in this dialog (e.g. qx_odbc) must be the same as the name of the database you want to connect to.

After that, follow the steps of the dialog for new data source creation.

You may want to set the ODBC_DSN variable:

If this variable not set, the 4GL considers that the DATABASE statement specifies the DSN name.
If you set this variable, the 4GL treats the value of the ODBC_DSN variable as the DSN name and DATABASE in such case points to a catalogue in the database to which the 4GL should switch when connected.
For the graphical clients, set the ODBC_DSN variable in the inet.env file.

You must also set the default database driver to odbc. If you connect to an SQL Server using the ODBC connection, you should set the database driver to sserver. Otherwise, the functionality can be restricted and in some cases the connection might fail.