|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Using Native Database Drivers
|
|
|
|
Drivers written specifically for accessing data sources directly from ColdFusion can be installed with the Enterprise version of the ColdFusion Application Server. Because they do not need to route SQL queries through the ODBC Driver Manager, they offer a performance advantage for large-scale data operations.
Open the ColdFusion Administrator Datasources Native Driver page to manage the drivers.
|
|
|
|
Bundled drivers |
|
|
|
The current set of native drivers contains:
- Oracle 7.3 -- requires Oracle 7.3.3 client
- Oracle 8.0 -- requires Oracle 8.0.4.0.0
- Sybase System 11 -- requires Sybase 11.1.1 client libraries. Sybase patch ebf 7729 is recommended
|
|
|
|
Attributes for enabling native drivers |
|
|
|
You can use the attributes listed below to override settings on the Administrator Native Driver page:
- DBSERVER -- Enter the Sybase or Oracle server name.
- DBNAME (Sybase only) -- Enter the database name.
- BLOCKFACTOR (ODBC and Oracle only) -- Set the maximum number of rows to return for each query. The default value is 1, the maximum value is 100. Certain ODBC drivers may dynamically reduce the block factor at runtime.
These attributes are supported in the CFQUERY, CFINSERT, CFUPDATE, CFGRIDUPDATE, and CFSTOREDPROC tags.
|
|
|
|
Note
|
|
|
For Sybase SQL Server the syntax for calling a stored procedure with CFQUERY is different for ODBC and the native Sybase driver. ODBC requires brackets and the word "call". The native driver does not have this requirement.
ODBC syntax:
<CFQUERY DATASOURCE="" NAME="">
{call dbo.stored_procedure_name}
</CFQUERY>
Native driver syntax:
<CFQUERY DATASOURCE="" NAME="">
dbo.stored_procedure_name
</CFQUERY>
|
|
|
  
|
|
|
AllaireDoc@allaire.com
Copyright © 1998, Allaire Corporation. All rights reserved.
|