User Guide

Chapter 4: Managing Data Sources 113
Connecting to Informix Data Sources (UNIX)
Before you can connect to an Informix data source through ColdFusion, you must
perform the following tasks:
1. Install the Informix ESQL.C9.13 client software.
2. Edit the following files: ColdFusion start script, SQLHOSTS, master NIS services,
and $INFORMIXDIR/etc/onconfig.
3. Stop and restart ColdFusion Server.
Installing the Informix ESQL.C9.13 Client Software
The Informix ESQL/C9.13 version client software does not ship with ColdFusion, but
you can download it from the Informix Web site:
http://www.intraware.com/guest/products/product.html?plne=000111
You can also download it from the Allaire FTP site:
ftp://www.allaire.com/incoming/CSDK.TAR.Z
You will need to uncompress, and untar this file into a separate subdirectory on your
server. For example:
/opt/isdk. This is the directory you will point to in the start script
as INFORMIXDIR
Run the script installclientsdk to install the client SDK.
Before you continue, make sure that you can connect to the Informix server from a
client other than ColdFusion or with a utility such as iconnect.
Editing the ColdFusion start script
Edit coldfusion/bin/start script so that it contains the following lines:
# Informix client directory
INFORMIXDIR=/opt/isdk;export INFORMIXDIR
INFORMIXSERVER=alldevtli;export INFORMIXSERVER
INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts;export INFORMIXSQLHOSTS
LD_LIBRARY_PATH=/usr/dt/lib:/lib:/usr/openwin/lib:$CFHOME/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql
Editing the SQLHOSTS file
Edit the sqlhosts file so that it contains the following lines:
dbserver nettype hostname service name
alldev onipcshm alldev online0
alldevtli ontlitcp alldev turbo
In these three lines:
• dbserver name matches the value in your Informix server /etc/onconfig file,
and also matches the INFORMIXSERVER environment variable in your /
coldfusion/bin/start
script.