This file contains minimal instructions on running Cold Fusion with
the Easysoft ODBC-ODBC Bridge. Easysoft tested Cold Fusion 4.5rc3.  If
you have ColdFusion MX this is no longer an ODBC application so will
not work with OOB. ColdFusion MX uses JDBC so use the Easysoft
JDBC-ODBC Bridge instead.

This document is not for ColdFusion MX which uses JDBC instead of
ODBC.

Please remember that cold fusion normally runs under a web server and
hence your configuration is multiple OOB clients on the same
machine. Each ODBC connection from Cold Fusion will consume one OOB
Server license slot. As a result you will probably need to purchase
more than a 1 connection based license for the OOB Server.

Install the ODBC-ODBC Bridge. In this document we assume you choose the
default installation path of /usr/local but amend references as
appropriate if you specified a different path.

Install Cold Fusion (remember that if you are installing Cold Fusion
to run with Apache you need to build Apache with mod_so support). The
default installation path for Cold Fusion is /opt and that is assumed
throughout this document. Amend as appropriate if you installed in a
different location.

Cold Fusion comes with the Merant ODBC Driver Manager. There is no
need to swap the Merant Driver Manager out, just let it know about the
ODBC-ODBC Bridge. After Cold Fusion installation our DM odbc.ini file
looked like this:

[ODBC Data Sources]

[ODBC]
Trace=0
TraceFile=odbctrace.out
TraceDll=@CFHOME@/lib/odbctrac.so
InstallDir=@CFHOME@/odbc

As the Cold Fusion administrative interface does not know about OOB
data sources you must add them manually. You can add OOB data sources
to the Merant DM configuration file at /opt/odbc/odbc.ini. OOB data sources
are added to this file as normal except you must add:

driver=<oob_install_path/easysoft/oob/client/libesoobclient.so.

e.g.

driver=/usr/local/easysoft/oob/client/libesoobclient.so

to each data source. An example odbc.ini file defining one data source
connecting Cold Fusion and the OOB client to a MS SQL Server database
through the OOB Server on demo.easysoft.com is:

[ODBC Data Sources]
mssqlsrv = MS SQL Server

[ODBC]
Trace=0
TraceFile=odbctrace.out
TraceDll=/usr/local/coldfusion/coldfusion/lib/odbctrac.so
InstallDir=/usr/local/coldfusion/coldfusion/odbc

[mssqlsrv]
Description = Test 
Server = demo.easysoft.com
port = 8888
Transport = tcpip
LogonUser = demo
LogonAuth = easysoft
TargetDSN = pubs
TargetUser = demo
TargetAuth = easysoft
Driver=/usr/local/easysoft/oob/client/libesoobclient.so
FileUsage=1

Version 1.0.0.0 of the OOB Server for Windows contained 2 bugs that
made it incompatible with Cold Fusion. If you have 1.0.0.0 of OOB for
Windows then please upgrade before using with Cold Fusion.



