Easysoft ODBC-ODBC Bridge Getting Started Guide

This guide leads you through the installation of the Easysoft ODBC-ODBC Bridge.

At the end, you'll be able to access your Windows ODBC data sources from Linux using a sample application included in the ODBC-ODBC Bridge distribution.

If you're installing to evaluate the ODBC-ODBC Bridge, the guide shows you how you to obtain a free trial license.

Assumptions

Step 2: Download the ODBC-ODBC Bridge

  1. Download the ODBC-ODBC Bridge distribution for Windows.
  2. Download the ODBC-ODBC Bridge distribution for Linux.

Step 3: Install the ODBC-ODBC Bridge server on Windows

  1. Double-click the Windows ODBC-ODBC Bridge distribution to start the installation.
  2. Choose Typical as the installation type.
  3. In the Username box, enter your Windows user name.
  4. In the Easysoft License Manager, supply your contact details, then choose Request License. Choose Trial and then choose ODBC-ODBC Bridge from the product list. Choose Next and then choose On-line Request if your Windows machine is connected to the Internet. Otherwise, choose View Request and email the contents of the license request screen to .

Step 4: Install the ODBC-ODBC Bridge client on Linux

  1. Use FTP or a similar product to transfer the Linux distribution in binary mode from your Windows machine to the /tmp directory of your client system.
  2. Log in to the Linux system as root and change to the /tmp directory.
  3. Untar the resulting file: 
    tar -xvf odbc-odbc-bridge-version-linux-x86-64-ul64.tar
  4. This will create a directory called odbc-odbc-bridge-version-linux-x86-64-ul64.

    Change into that directory.

  5. Enter ./install to begin the install.
  6. Add this data source to /etc/odbc.ini: 
    [mydemo]
Driver          = OOB
SERVERPORT      = SERVERNAME:8888
TARGETDSN       = TARGETDSN
LOGONUSER       = LOGONUSER
LOGONAUTH       = LOGONAUTH
TARGETUSER      = TARGETUSER
TARGETAUTH      = TARGETAUTH

    where:

    • SERVERNAME is the host name or IP address of the Windows machine.
    • TARGETDSN is the ODBC system data source on the Windows machine.
    • LOGONUSER and LOGONAUTH are your Windows user name and password for SERVERNAME
    • TARGETUSER and TARGETAUTH are the user name and password for the target database, if required by the database.

Step 5: Access your data sources

  1. Change directory to /usr/local/easysoft/unixodbc/bin.
  2. Use isql to access your Windows ODBC data sources from Linux, enter: 
    ./isql -v mydemo
  3. At the prompt, you'll be able to enter SQL statements to query your database (for example, select * from mytable) or you can enter help to display a list of tables in your database.

What next?

Further support