Linux ODBC: StarSQL

starsql64 is a prerequisite of the sqdr package, and is likely to be present when you install sqdr or use the Docker container.

If it is necessary to install StarSQL, it may also install unixODBC from the Linux distribution as a prerequisite. after SQL Server so it uses the unixODBC package installed from Microsoft (or Linux distro) rather than its own packaging of unixODBC, so that all drivers are registered in /etc/odbcinst.ini rather than /usr/local/etc/odbcinst.ini.

Install the compatibility package for OpenSSL 1.0.x

# yum install compat-openssl10

Use the "thin" RPM installer for StarSQL (which does not contain unixODBC or a setup shell script) e.g.

# rpm -i starsql64-6.50-1.x86_64.rpm

Examine /etc/odbcinst.ini and verify that both driver names (StarSQL64 and StarSQL (64-bit) are present.

Create an ODBC DSN (data source) using a text edit.

A typical DSN looks like:

[ELMSQ]
Driver=StarSQL (64-bit)
Server=MYRDB
Hostname=myhost
Port=446
PkgColId=STARSQL
IsolationLevel=2
SSL=No
ICONV4UTF8=Y

IsolationLevel=2 is required for Db2 for i hosts.

To use SSL:

  1. Set Port to the appropriate port (which will differ from the unencrypted port)

  2. set SSL=Y

  3. Import the CA certificate into the OpenSSL certificate store

# cp /tmp/mycacert.pem /etc/pki/ca-trust/source/anchors/
# update-ca-trust extract

See SSL/TLS Hints for StarSQL/UNIX for details.