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

  • You're installing the XML-ODBC Server a UNIX or Linux system for which you have root access.
  • You already have a system data source configured on your UNIX or Linux system and have a user name and password for the target database (if applicable).
  • You have unrestricted access to the Internet so that you can complete the licensing part of the installation routine. If you're not online, you can get a license from Easysoft by telephone or email. Refer to the Easysoft Licensing Guide (HTML or PDF) for further information.

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?

  • You're now ready to access the XML-ODBC Server from your own applications. The drive:\Program Files\Easysoft\XML-ODBC Server\Clients directory contains sample applications, which you can use as a starting point.

Further Support