User Guide

120 Administering ColdFusion Server
script is pointing to the Sybase client directory and not the Sybase server
directory. Both of these directories contain an interfaces file.
When you’ve completed all the steps in this section, you will need to stop and restart
ColdFusion services to reload the odbc.ini file.
The /opt/coldfusion/bin/start script
#!/bin/sh
# start - setup environment and run Cold Fusion servers
# This script should be run as root.
# Run as root, we are able to start the system registry deamon
# and then change to the Cold Fusion userid to start the servers
# Set during install
CFHOME=/opt/coldfusion
CFUSER=nobody
# Sybase Open Client directory
SYBASE=/work/sybclient11.1;export SYBASE
#II_SYSTEM=/home
# Set library search path
# NOTE: Add your database client library directory to the FRONT
# of this list
# Example:
# LD_LIBRARY_PATH=$SYBASE/lib:/usr/dt/lib:/lib:/usr/openwin/lib:
# $CFHOME/lib
LD_LIBRARY_PATH=$SYBASE/lib:/usr/dt/lib:/lib:/usr/openwin/lib:$CFHOME/
lib
# This is the list of variables that Cold Fusion will see
# Add any special Database environment varaibles here
VAR_LIST=""LD_LIBRARY_PATH CFHOME SYBASE ORACLE_HOME INFORMIXDIR
INFORMIXSERVER II_SYSTEM""
Using ColdFusion to Create a Data Source
The MERANT ODBC drivers that ship with all UNIX versions of ColdFusion include a
FoxPro 2.5/dBase driver you can use to create a database file in a CFQUERY with
standard SQL syntax even if you don’t have an Oracle, Informix, Sybase, or DB2
database.
Note See Appendix A in the MERANT DataDirect ODBC Drivers manual for
details about SQL statements used for flat file drivers.
The following example creates tables in a data source called newtable. This example
uses a coffee inventory model as a theme for the data. Before you can run this code,