Install the TS ODBC DataServer Client (UNIX/Linux)

The TS ODBC DataServer provides access to Thoroughbred data from ODBC-enabled applications. This document will detail the components and installation steps for the TS ODBC DataServer client for UNIX/Linux.

Contents of the Client Software

The following driver files are included in the product:

libtfodbcst.so - Single-Tier Driver Library
libtfodbcsS.so - Single-Tier Setup Library
libtfodbccl.so - Multi-Tier Driver Library
libtfodbccS.so - Multi-Tier Setup Library

System Requirements

Client Platforms Supported

Linux kernel 2.4.20 and later – verify with uname -a
unixODBC 2.2.8 and later – verify with odbcinst -j

Server Platforms Supported

The server component software of TS ODBC DataServer is available on various UNIX/Linux platforms and Windows. Please call your Thoroughbred Sales Representative for a list of available servers.

Installing the Client Software

Load the Drivers

The driver files may be installed in any directory, for example /usr/local/lib. The following examples assume the downloaded product file has been copied into /usr/local/lib

cd /usr/local/lib
cpio -ivBud <TSLNX

Build Entries in odbcinst.ini

Add a section to odbcinst.ini for each driver you want to use. Locate the odbcinst.ini on your system by executing the odbcinst command (which is supplied as part of the unixODBC package) as follows:

odbcinst -j

The system will return information similar to the following:

unixODBC 2.2.10
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini

The odbcinst.ini file will be stored in the directory referenced by the ‘DRIVERS’ line.

The logical name for a driver is enclosed in brackets at the beginning of a section. This name will be used when defining Data Sources. Insert the following information into the odbcinst.ini file to add the Thoroughbred ODBC drivers to the system:

[TSODBCST]
Description = TS ODBC DataServer for unixODBC (Single-Tier)
Driver = /usr/local/lib/libtfodbcst.so
Setup = /usr/local/lib/libtfodbcsS.so
FileUsage = 1

[TSODBCCL]
Description = TS ODBC DataServer for unixODBC (Multi-Tier)
Driver = /usr/local/lib/libtfodbccl.so
Setup = /usr/local/lib/libtfodbccS.so
FileUsage = 1

Define Data Sources

You can define Data Sources manually by editing odbc.ini. Refer to the ‘SYSTEM DATA SOURCES’ line of the odbcinst command output for the odbc.ini file location on your system. The following is a sample Multi-Tier definition:

[SERVER]
Description = ODBC Test DataSource
Driver = TSODBCCL
HOST = your.server.com
UID = abc

In this example, SERVER is the name of the definition. It must match a name you created using the ODBC Expose Utility. This name is case sensitive.

The Description is a required keyword and should describe the Data Source.

The Driver keyword is also required and must match a driver that you have defined in odbcinst.ini.

The HOST keyword is required for Multi-Tier connections.

The following are optional keywords recognized by the TS ODBC drivers.

UID: A Dictionary-IV operator code may be stored for login.
PWD: The password associated with the listed UID.
HOST: A URL used to connect to a remote TS ODBC DataServer.
PORT: The port number to use for remote conections.

Security

The drivers are not capable of presenting dialogs for such things as logins and passwords. If a Dictionary-IV operator code and password is required it must be provided in the odbc.ini file or by the ODBC client you are using. LINK passwords and Record Access passwords are not allowed in this version.

Additional Resources

Refer to the TS ODBC Reference Manual for details about the ODBC Expose Utility.

The ODBCConfig program, if available, is an X-Windows client useful for maintaining Data Source configurations. The setup library must have been installed for the program to work. The program’s sole purpose is to display and edit the odbc.ini and odbcinst.ini files. It cannot handle the password and translation features of the TS ODBC drivers.

You can find more information about unixODBC at www.unixODBC.org.

From the TS ODBC DataServer Installation and Activation Guide, version 8.9.1. Open this page in the PDF