![]() ![]() ![]() |
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.
The current set of native drivers contains:
You can use the attributes listed below to override settings on the Administrator Native Driver page:
These attributes are supported in the CFQUERY, CFINSERT, CFUPDATE, CFGRIDUPDATE, and CFSTOREDPROC tags.
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.