KCML ODBC Server installation

The ODBC server files are installed as part of the KCML product. However it is also possible to get the latest versions from the KCML download area. This could be important if installing on an existing server where the KCML could be quite old.

The executables are operating system version specific. The ODBC server software for the range of supported operating system platforms is available from https://www.adpdsionline.com.

For Windows systems there will be a single setup.exe installation file but for Unix servers there is a kisam.Z file and an 'ODBC installation script', odbcinst. This kisam.Z is a compressed cpio archive file.

Server installation under Unix

You must be logged on as the root user to install the ODBC driver.

Copy the 'odbcinst' and 'kisam.Z' files into the /tmp directory of the Unix server and make sure the odbcinst installation script has execute permissions by typing in:

cd /tmp
chmod +x odbcinst
To execute the script and initiate the install type: 
./odbcinst

This will silently perform the following tasks:

  1. Install kiodbc, sql, kconvdd and getid files into /usr/local/kcml. If you wish a different installation directory amend the $TARGET variable with the odbcinst Unix script or utilize the -d directory command line parameter.
  2. Add appropriate service entries to /etc/services and /etc/inetd.conf (/etc/xinetd.d/kisam on Linux)
  3. Restart inetd TCP/IP service daemon (xinetd under Linux)

ODBC requires an entry in the licence file so you may need to procure an updated licence file from your KCML dealer. If you do not have a lic.txt with an [ODBC] entry in it, you must execute the 'getid' program that has just been installed. For example:

cd /usr/local/kcml
chmod +x getid
./getid

This will return a 16 digit number which you can send this number, together with the serial number from the top of the file, to your KCML dealer who will in return send you back a licence file.

You should now backup the existing licence file and copy the updated licence file, lic.txt, into the /usr/local/kcml installation directory.

To verify that the kiodbc files for the correct operating system type have been installed, execute kiodbc so that it displays the 'version information'. Type:

cd /usr/local/kcml
./kiodbc -v
This should display a message something like this: 
./kiodbc release version 07.10.00.21240 (protocol 2.4) Linux 2.6 x86

If no output is shown, or it appears incorrect seek help through your dealer's support channel.

Server installation under Windows

This is is a two-tier implementation similar to Unix systems where the ODBC server is installed centrally on an Windows server which runs a listening service configured by 'kservadm'. This service can either be kiodbc.exe listening on port 747, or port 790 for the Connection Manager.

The Windows setup file must be run by a user who has administrative access rights.

Copy the setup.exe file to the Windows machine and execute it by double clicking on the file from within Windows Explorer. This automatically extracts the files from the setup file into a temporary directory and then prompts you to click on OK to continue installation. A default installation directory is presented plus two check boxes that you can 'un-check' if you wish the installer to install the files without registering them within Windows. Leave the default settings as they are unless you feel you need to change them. If no lic.txt exists within the installation directory you will be prompted for either the location of the lic.txt, or a dialog allowing you to register the product and obtain a licence file.

This installs and registers the following files: