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.
Summary of Contents for COLDFUSION 5-ADVANCED ADMINISTRATION
Page 1: ...Macromedia Incorporated Advanced ColdFusion Administration ColdFusion 5...
Page 20: ......
Page 56: ...38 Chapter 1 Advanced Data Source Management...
Page 74: ...56 Chapter 2 Administrator Tools...
Page 76: ......
Page 86: ...68 Chapter 3 ColdFusion Security...
Page 87: ...To Learn More About Security 69...
Page 88: ...70 Chapter 3 ColdFusion Security...
Page 130: ...112 Chapter 5 Configuring Advanced Security...
Page 132: ......
Page 154: ...136 Chapter 6 Configuring Verity K2 Server...
Page 162: ...144 Chapter 7 Indexing XML Documents...
Page 202: ...184 Chapter 8 Verity Spider...
Page 236: ...218 Chapter 10 Verity Troubleshooting Utilities...
Page 238: ......
Page 348: ...330 Chapter 14 ClusterCATS Utilities...
Page 349: ...Using sniff 331...
Page 350: ...332 Chapter 14 ClusterCATS Utilities...
Page 362: ...344 Chapter 15 Optimizing ClusterCATS...
Page 372: ...354 Index...