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>


 
 
BackUp LevelNext
 
 

allaire     AllaireDoc@allaire.com
    Copyright © 1998, Allaire Corporation. All rights reserved.