ODBC-ODBC Bridge
Getting Started Guide
Easysoft ODBC-ODBC Bridge Getting Started
This zip file contains all the software you will need to connect from a Linux machine over the Easysoft ODBC-ODBC
Bridge to an ODBC data source residing on a Windows machine.
The purpose of this guide is to lead you through the installation of the Easysoft ODBC-ODBC Bridge
Client on a Linux machine and the Server on a Windows machine.
At the end of this process you will be able to access your Windows ODBC data sources from Linux using isql, an interactive SQL tool installed with unixODBC, the open source Driver Manager that is installed alongside the Easysoft ODBC-ODBC Bridge
Client and then test your own Linux application.
The process will take 15-30 minutes.
If you are installing in order to evaluate the Easysoft ODBC-ODBC Bridge, the process will allow you to obtain a free trial license.
Client versions for alternative platforms can be obtained from the Easysoft
website. The instructions for the Linux client installation of the Easysoft ODBC-ODBC Bridge are quite specific. For installation details on any alternative platforms please refer to the product manual included within the Zip file.
If you do not have the Acrobat reader installed it may be downloaded from
http://www.adobe.com/products/acrobat/readstep2.html
If you have already installed the Easysoft ODBC-ODBC Bridge and need help using a particular development tool or application, more information can found in the Applications and Interfaces section of the Easysoft
Website these include specific tutorials on Perl and PHP:
http://www.easysoft.com/products/2002/applications.phtml
http://www.easysoft.com/products/9999/documentation.phtml?product=2002
or by contacting support@easysoft.com
Assumptions
You have 'unzip' utility installed on the machine that you have downloaded this file onto. We used Winzip (http://www.winzip.com/) to create the archive but other unzip utilities will allow
un-compression.
*
The Easysoft ODBC-ODBC Bridge Server component is to be installed Windows NT or
later. You will need to note the full computer name or IP address of this machine.
*
You are familiar with the Microsoft ODBC driver manager, have configured one or more System Data Sources and have the necessary usernames and passwords to access your target databases.
*
The Easysoft ODBC-ODBC Bridge Client component is to be installed on a Linux system to which you have root access.
*
You are using Internet Explorer as your browser.
*
The Easysoft License Manager needs access through your firewall to allow a
remote license to be added to your machine. Where a firewall blocks access or
your Internet connection is limited Easysoft also offer the ability to obtain
licenses from the Easysoft Website from any machine:
http://www.easysoft.com/sales/autolicense.phtml
or via e-mail, fax or phone. Full details can be found within the edalicensing.pdf.
Please refer to the product manual if your installation does not comply with any of these requirements or contact
support@easysoft.com
Overview
The process is in three steps:
1. Install the Easysoft ODBC-ODBC Bridge Server component on Windows.
2. Install the Easysoft ODBC-ODBC Bridge Client component on Linux.
3. Access your data sources.
Procedure
Step 1. Install the Easysoft ODBC-ODBC Bridge Server component on Windows
* Double click on the file odbc-odbc-bridge-2_0_0-windows-x86.exe found within the Zip file to start the installation. Accept all the defaults, leaving Typical as the installation type. On the
OOB Server Administration dialog box enter a valid Windows user name.
Make sure that you select the Server to be
installed 'Initially Open'
*
OK the default data source.
*
Easysoft License Manager will be loaded during the installation. This can
be used to request a trial license:
o On the main window complete all of the Contact Information and click Request License.
o In License Type ensure that Time Limited Trial is selected and click Next.
o Select Easysoft ODBC-ODBC Bridge from the drop-down list of products and click Next.
o Click On-Line Request. You will get a message to tell you that your license has been added. Click OK.
o Click Finish on the main window.
*
Complete the installation process.
*
Before testing the server installation restart the Easysoft ODBC-ODBC Bridge
service from the service manager loaded through Start>Settings>Control
Panel>Administrative Tools>Services this will allow the license to be
loaded. Then test the installation:
o Choose Programs > Easysoft > ODBC-ODBC Bridge > OOB Web Administrator from the Windows Start menu. This will start your browser with the URL to the OOB Server Web Administrator.
If you get a message saying the requested URL could not be retrieved then you may have to examine your proxy settings or change the URL to http://mywindowsmachine.domain:8890 where mywindowsmachine is the name of you machine and domain is the internet domain your machine is in.
o Click Datasources for a list of the System Data Sources you will be able to access.
You need to note down which of these you want to connect to as you will
reference it later.
Step 2. Install the Easysoft ODBC-ODBC Bridge Client component on Linux
*
Before leaving Windows, use FTP or a similar product to transfer the
odbc-odbc-bridge-2.0.0-linux-x86-glibc.tar file in binary mode to the /tmp directory of your client system.
*
Login to the Linux system as root and change to the /tmp directory.
*
Untar the resulting file:
tar -xvf odbc-odbc-bridge-2.0.0-linux-x86-glibc.tar
*
This will create a directory called
odbc-odbc-bridge-2.0.0-linux-x86-glibc
cd odbc-odbc-bridge-2.0.0-linux-x86-glibc
*
Type ./install to begin the install. Select the defaults except:
o Choose to install unixODBC
o Choose to install the Easysoft ODBC-ODBC Bridge into unixODBC
o Choose NOT to install the Easysoft ODBC-ODBC Bridge Server component
*
Edit the file /etc/odbc.ini, adding a new entry as follows:
[mydemo]
Driver = OOB
SERVERPORT = SERVERNAME:8888
TRANSPORT = tcpip
TARGETDSN = TARGETDSN
LOGONUSER = LOGONUSER
LOGONAUTH = LOGONAUTH
where:
o mydemo is the name of the local data source
o SERVERNAME is the Windows hostname or IP address where you have installed the ODBC-ODBC Bridge
Server
o TARGETDSN is the ODBC system data source on the Windows system to which you wish to connect
o LOGONUSER and LOGONAUTH are your Windows username and password on SERVERNAME
Step 3. Access your data sources
*
Change directory to /usr/local/easysoft/unixodbc/bin.
*
To access your Windows ODBC data sources from Linux using isql, type:
./isql -v mydemo sqluser sqlpassword
Note that sqluser and sqlpassword are the user and password for the target database.
*
At the prompt you will be able to enter SQL commands to query your database (e.g. select * from mytable) or you can type help to display a list of tables in your database.
What Next?
*
You are now ready to use the Easysoft ODBC-ODBC Bridge with your own applications or development tools.
*
Easysoft provide additional application specific tutorials, which can be found in the following directory on you Linux machine - /usr/local/easysoft/oob/doc
Further Support
*
The Easysoft ODBC-ODBC Bridge product manual (edaoob-20.pdf included within this download) provides full detailed instructions for the installation process.
*
You can refer to our online FAQ http://www.easysoft.com/products/9999/faq_questions.phtml?product=2002
*
You can mail questions to support@easysoft.com.
*
Comments
*
We welcome any comments, corrections or improvements to this document. Please send your suggestions to
documentation@easysoft.com.
*
©1993-2005 Easysoft Limited