Easysoft XML-ODBC Server UNIX and Linux Getting Started Guide

This guide shows you how to download, install, and license the Easysoft XML-ODBC Server.

At the end, you will be able to access your ODBC data source using a sample client application supplied and create your own applications using the development tool of your choice.

Assumptions

Step 1: Download the XML-ODBC Server

  1. Download the XML-ODBC Server.
  2. Follow your browser instructions to save the distribution file to a temporary directory on your Unix or Linux machine.

Step 2: Install and configure the XML-ODBC Server

  1. On your UNIX or Linux machine, change into the directory where you saved the XML-ODBC Server distribution.
  2. Untar the distribution file using the following command, substituting the version number and platform from your distribution filename:
    tar xvf xml-odbc-version.linux-glibc.tar

    At the end of the installation, you will have installed and licensed the XML-ODBC Server.

Step 3: Access your data sources

  1. This example uses the sample C client application included with the distribution.

    You need the following details:

    • host: The server name or IP address of the XML-ODBC Server host.
    • port: The port number configured for the server, by default 8895.
    • DSN: The name of the ODBC data source you need to access.
    • UID: The database user name (if applicable).
    • PWD: The database password.
    • SQL: The SQL statement that you want to execute.
  2. In a command shell, cd into:
    /usr/local/easysoft/xml-odbc/clients/c
  3. Run xmlodbc_client:
    xmlodbc_client -h host -p port -c 'DSN=DSN;UID=UID;PWD=PWD;' -s 'SQL;'

    If successful, the server response will be displayed as XML.

What next?

Further Support