Linux Client Supplement
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 Linux.
Client Platforms Supported
Section titled “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
Section titled “Server Platforms Supported”The server component software of TS ODBC DataServer is available on various UNIX platforms and Windows. Please call your Thoroughbred Sales Representative for a list of available servers.
Driver Files
Section titled “Driver Files”The following 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
Installing/Upgrading the Linux Client Software
Section titled “Installing/Upgrading the Linux Client Software”Load the Drivers
Section titled “Load the Drivers”The driver files may be installed in any directory. The following examples assume they are installed in /usr/local/lib.
Move the downloaded product file into the /usr/local/lib directory.
cpio -ivBud < TSLNX
Build Entries in odbcinst.ini
Section titled “Build Entries in odbcinst.ini”Add a section to odbcinst.ini for each driver you want 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
Section titled “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 connections
Security
Section titled “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
Section titled “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 ODBC Client Capability Supplement, version 8.9.1. Open this page in the PDF