MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION..., Руководство пользователя, Страница: 141 / 350

Chapter 4: Managing Data Sources 119
Tips for Connecting to Sybase System 11 (UNIX)
Keep the following 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 will 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. See “The /opt/coldfusion/bin/start
script” on page 120 for an example.
•
Set up an entry in the interfaces file for the particular database you want to
connect to. The interfaces file is in the $SYBASE directory, for example,
/opt/
sybase or /work/sybase or wherever the Sybase client software was installed.
You can use a Sybase utility called
sybinit
on UNIX to update this file.
Note
If the Sybase database is on the same server as ColdFusion make sure the
$SYBASE environment variable that you set up in the ColdFusion start
Workstation ID The workstation ID used by the client.
Performance Row Limit — The number of rows the driver retrieves from the
server for a fetch. Enabling this option can increase performance
by reducing network traffic.
Create stored procedures — This option determines whether
stored procedures are created on the server for every call to
SQLPrepare. When enabled, stored procedures are created for
every call to SQLPrepare. This setting can result in bad
performance when processing static statements.
When disabled, the driver does not create stored procedures.
Disable database cursors for Select statements — Determines
whether database cursors are used for Select statements. In
some cases performance degradation can occur when
performing large numbers of sequential Select statements
because of the amount of overhead associated with creating
database cursors.
Customization Enable Password Encryption from Open Client Library to
Server — Determines whether password encryption can be
performed from the Open Client Library to the server.
MERANT Sybase System 11 ODBC Options (Continued)
Option Description