User Guide

Connecting to Sybase Databases 33
Native: Sybase 11 Driver options
To connect to Sybase System 11 databases on Windows NT and UNIX, you must first
install the Sybase client software, Sybase Open Client version 11.1.0 with Update
11.1.1 applied.
To use the native driver:
1 Install the Sybase Open Client version 11.1.0 (with Update 11.1.1 applied) client
software.
2 Verify the connection to the database using a tool like Sybase SQL Advantage.
3 Create the data source in the ColdFusion Administrator, Native Drivers page.
4 You set these options when you configure a ColdFusion data source.
Tips for connecting to Sybase System 11 (UNIX)
Keep the following tips in mind when you create Sybase ColdFusion data sources:
• You can set up the Sybase data source using the ColdFusion Administrator Data
sources page.
• You need Sybase Open Client version 11.1.0 with Update 11.1.1 applied on your
server. This software does not ship with ColdFusion.
• Check that the SYBASE environment variable is set up in the
/opt/coldfusion/
start
script. Also check that the LD_LIBRARY_PATH has the $SYBASE/lib
directory in the beginning of its path; for an example, see “The /opt/coldfusion/
bin/start script” on page 34.
• Set up an entry in the interfaces file for the particular database that you want to
connect to. The interfaces file is in the $SYBASE directory; for example,
/opt/
sybase
or /work/sybase or wherever you installed the Sybase client software. You
can use a Sybase utility called
sybinit on UNIX to update this file.
Option Description
Data Source Name A name for your ODBC data source.
Description Descriptive information about the data source.
Server Enter the name of the server hosting the Sybase System 11
database.
Default Database Enter the name of the default database to use on the
specified server.
Enable RAISERROR Select to obtain user-defined errors
from stored procedures and triggers.