This guide describes the required prerequisistes, installation and configuration steps of the ODBC Linux driver.

This guide describes the installation of the ODBC driver for Centos 7.3. For other operating systems please contact the SQream support team.

1. Prerequisites: Install UnixODBC

Download unixODBC-2.3.4.tar.gz from here: ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz

Install unixODBC based on the instructions: http://www.unixodbc.org/

2. Install the SQream ODBC Driver and Configuration

2.1. Download the SQream ODBC driver

Download the SQream ODBC driver for Linux from: https://sqream.com/product/client-drivers/

Untar (extract) the sqream_odbc.tar.gz file into any temporary location:

tar -xf	sqream_odbc.tar.gz

The extracted sqream_odbc.so file is the ODBC driver file.

2.2. Copy the SQream ODBC driver

Copy the sqream_odbc.so file to the directory you want the SQream ODBC driver to reside.
For example:

/home/sqream/ODBC/sqream_odbc.so

This is the path and file name you will use in next steps.

2.3. Locate the ODBC configuration files

Use odbcinst to print your ODBC configuration.
Run:

odbcinst -j | grep odbc

This shows you the location of the odbcinst.ini and odbc.ini file in your system.
odbcinst.ini = specifies the drivers
odbc.ini = specifies the data sources

For example:

[[email protected] ~]$ odbcinst -j | grep odbc
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /home/sqream/.odbc.ini

2.4. Add the SQream DB driver as a data provider for unixODBC

Edit the odbcinst.ini file you found in the previous step.

Verify that the odbcinst.ini file contains the following lines:

[sqream64]
Description=sqream64
Driver={path of sqream_odbc.so}
Setup={path of sqream_odbc.so}

[ODBC]
Trace={yes|no}
TraceFile={path and file name of the trace file}

For example:

[sqream64]
Description=sqream64
Driver=/home/sqream/ODBC/sqream_odbc.so
Setup=/home/sqream/ODBC/sqream_odbc.so

[ODBC]
Trace=no
TraceFile=/home/sqream/ODBC/trace.tmp

2.5. Add a DSN for your SQream DB database

Edit the odbc.ini file and add the ODBC DSN information.
Verify that the odbc.ini file contains the following lines:

[{DSN name}]
Driver={path of sqream_odbc.so}
Description=sqream64
Server={IP address of the SQream server}
Port={Listener port of SQream}
Database={SQream database to connect to}
User={SQream DB user}
Password={password of the above SQream DB user}
Cluster={true | false}
ssl={true | false}

For example:

[sqreamOn251]
Driver=/home/sqream/ODBC/sqream_odbc.so
Description=sqream64
Server=192.168.0.251
Port=3108
Database=master
User=sqream
Password=sqream
Cluster=true
ssl=false

3. Test the SQream ODBC Driver

3.1. Use the ISQL utility to test the driver

ISQL is a unixODBC command-line interactive SQL tool and can be used as a tester. No additional installation is required (UnixODBC is a pre-requisite for SQream).
https://www.systutorials.com/docs/linux/man/1-isql/

On the command line, specify the DSN name:

isql [DSN name]

For better error message:

isql -v [DSN name]

For the above example this would be:

isql sqreamOn251

Copyright © 2010-2018. All rights reserved.

This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchant- ability or fitness for a particular purpose.

We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document.

This document may not be reproduced in any form, for any purpose, without our prior written permission.