![]() ![]() ![]() |
When creating or updating an ODBC data source, you use the Create ODBC Data Source page in the Administrator. This page offers a number of options for configuring your ODBC data source. The options visible on the ODBC Data Source page vary based on the database driver being used.
For information about driver-specific options, refer to the following sources of information:
<installdir>/odbc/doc/odbchelp.pdf
.
ODBC drivers on Solaris are supplied by Intersolv.
On Solaris, you need to edit the coldfusion/bin/start
script to include the database variable, for example, ORACLE_HOME
, SYBASE
, or INFORMIXDIR
and the library path set in LD_LIBRARY_PATH
.
ColdFusion ODBC options for dBase/FoxPro data sources are described in the following table.
Intersolv dBase/FoxPro ODBC Options | |
---|---|
Option | Description |
Data Source Name | A name for your ODBC data source. |
Description | Descriptive information about the data source. |
Database Directory | The path and filename of the Excel workbook you want to use as the ODBC data source. |
Database Version | Enter the version number of the Excel workbook you want to use. ColdFusion supports Excel versions 3.4, 4.0, and 5.0. |
Driver Settings | Use lowercase file extension (.dbf) -- Specifies whether lowercase file extensions are accepted. If enabled, lowercase extensions are accepted. If disabled, only uppercase extensions are accepted. |
Use international collating sequence -- Determines the order that records are retrieved when you issue a Select statement with an Order By clause. If disabled, the driver uses the ASCII sort order. This order sorts items alphabetically with uppercase letters preceding lowercase letters. For example, "A, b, C" would be sorted as "A, C, b." If enabled, the driver uses the international sort order as defined by your operating system. This order is always alphabetic, regardless of case; the letters from the previous example would be sorted as "A, b, C." |
ColdFusion ODBC options for dBase/FoxPro data sources are described in the following table.
Intersolv dBase/FoxPro ODBC Options | |
---|---|
Option | Description |
Data Source Name | A name for your ODBC data source. |
Description | Descriptive information about the data source. |
Database Directory | The path and filename of the directory you want to use as the ODBC data source. |
Extensions List | Lists the file name extensions of the text files on the data source. To use all files in the directory, enter *.*. To use only those files with certain extensions, add each extension you want to use. |
ColdFusion ODBC options for IBM DB2/6000 data sources are described in the following table.
Intersolv IBM DB2/6000 ODBC Options | |
---|---|
Option | Description |
Data Source Name | A name for your ODBC data source. |
Description | Descriptive information about the data source. |
Database Name | The name of the DB2/6000 database. |
Cursors | Preserve cursors at the end of each transaction --Enable this option if you want cursors to be held at the current position when the transaction ends. Doing so may impact the performance of your database operations. |
ColdFusion ODBC options for Sybase 11 data sources are described in the following table.
Intersolv Sybase System 11 ODBC Options | |
---|---|
Option | Description |
Data Source Name | A name for your ODBC data source. |
Description | Descriptive information about the data source. |
Database Name | The name of the database to which you want to connect. |
Server Name | The name of the server containing the Sybase tables you want to access. If not supplied, the initial default is the server name in the DSQUERY environment variable. On UNIX, the name of a server from your $SYBASE/interfaces file. |
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. |
ColdFusion ODBC options for Oracle 8 data sources are described in the following table.
Intersolv Oracle 8 ODBC Options | |
---|---|
Option | Description |
Data Source Name | A name for your ODBC data source. |
Description | Descriptive information about the data source. |
Connect String | The client connection string designating the server and database to be accessed. |
Performance | Include REMARKS in Catalog Functions -- Specifies whether the result column REMARKS for the catalog functions SQLTables and SQLColumns and COLUMN_DEF for the catalog function SQLColumns have meaning for Oracle. |
Customization | Enable scrollable cursors -- Enables scrollable cursors for the data source. Both Keyset and Static cursors are enabled. |
ColdFusion ODBC options for INFORMIX 7.x/9.x data sources are described in the following table.
Intersolv INFORMIX 7.x/9.x ODBC Options | |
---|---|
Option | Description |
Data Source Name | A name for your ODBC data source. |
Description | Descriptive information about the data source. |
Database Name | The name of the database to which you want to connect. |
Server Host Name | The name of the machine on which the INFORMIX server resides. |
Use INFORMIX registry for Logon ID and Password -- Determines whether the drive reads the Logon ID and Password directly from the INFORMIX registry. | |
Cursors | Preserve cursors at the end of each transaction -- Determines whether cursors will be preserved or closed at the end of each transaction. Enable this attribute if you want cursors to be held at the current position when the transaction ends. Enabling this option may impact the performance of your database operations. |
Enable scrollable cursors -- Determines whether the driver provides scrollable cursors. The INFORMIX driver can use scrollable cursors only if there are no long columns (SQL_LONGVARCHAR or SQL_LONGVARBINARY) in a Select list. If you enable this option, you must not include long columns in the Select list. | |
Enable Insert cursors -- Determines whether the driver can use Insert cursors during parametrized inserts. |
ColdFusion ODBC options for OpenIngres data sources are described in the following table.
Intersolv OpenIngres ODBC Options | |
---|---|
Option | Description |
Data Source Name | A name for your ODBC data source. |
Description | Descriptive information about the data source. |
Database Name | The name of the database to which you want to connect. |
Server Name | The name of the virtual node that you defined using the OpenIngres NETU utility. This virtual node tells OpenIngres which system to call, how to call it, and the user's name and password. |
OpenIngres Options ID |
The flags allowed on the OpenIngres SQL command line. Examples are:
|
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. | |
Driver Settings | Enable OpenSQL -- Provides the ability to access data sources using OpenSQL. |
![]() ![]() ![]() |
AllaireDoc@allaire.com
Copyright © 1998, Allaire Corporation. All rights reserved.