MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION..., Manual

Page: 114 / 350

92 Administering ColdFusion Server
Connecting to dBase Databases
ColdFusion lets you access dBase databases from both Windows NT and UNIX, via
ODBC drivers.
Configuring dBase Options (Windows)
If ColdFusion Server is installed on a Windows NT server, you can configure Microsoft
SQL Server as a ColdFusion data source using any either an ODBC or OLE DB driver.
Performance Repeated Cache Size — Determines whether all Update and
Insert statements are to be run as repeated statements. This
attribute improves the performance of applications that
repeat the same set of SQL statements.
Long Data Buffer — An integer value that specifies, in 1024-
byte multiples, the maximum amount of data that will be
transferred to the client for unbound long data result
columns.
Optimize SELECT statements as repeated queries —
Determines whether the driver optimizes Select statements or
runs them as repeated queries.
User Select Loops instead of Cursors — Enables the retrieval of
multiple rows using the Select loop model instead of cursors.
Substitute parameters for hard coded values in repeated
statements — Determines whether the driver substitutes
parameters for hard coded values in repeated statements. This
option is convenient in applications that do not use dynamic
parameters.
Enable OpenSQL Lets you access data sources using OpenSQL.
MERANT OpenIngres 1.x/2.x ODBC Options (Continued)
Option Description