BackUp LevelNext

ODBC Data Source Options (Windows)

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:

Microsoft SQL Server ODBC options

ColdFusion ODBC options for Microsoft SQL Server data sources are described in the following table.

Microsoft SQL Server ODBC Options 
Option Description
Data Source Name A name for your ODBC data source.
Description Descriptive information about the data source.
Server The name of the server hosting the database you want to use.
Use Trusted Connection -- Allows SQL Server to authenticate on the user's Windows NT login. You can use this option if the SQL Server database is using an Integrated or Mixed security mode. Integrated security uses NT authentication schemes for all connections. Only trusted connections are allowed to connect to SQL Server. It's not necessary to populate the ColdFusion username and password fields because SQL Server ignores these values. Mixed security allows both trusted and nontrusted connections. If the username and password are left blank, SQL Server will use NT domain credentials. However, if you do pass a username and password, SQL Server tries to authenticate using the passed information.
Login Info Database -- The name of the SQL Server database.
Language -- The national language used by SQL Server.
Generate Stored Procedure for Prepared Statement -- Stored procedures are created for prepared statements when this option is selected. The SQL Server driver prepares a statement by placing it in a procedure and compiling that procedure.
Translation Convert OEM to ANSI characters -- If the SQL Server client computer and SQL Server are using the same non-ANSI character set, select this option. For example, if SQL Server uses code page 850 and this client computer uses code page 850 for the OEM code page, selecting this option will ensure that extended characters stored in the database are properly converted to ANSI for use by Windows-based applications.

dBase ODBC Options

ColdFusion ODBC options for dBase data sources are described in the following table.

dBase 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 dBase database you want to use as an ODBC data source.
Database Version Enter the version number of the dBase database you want to use. ColdFusion supports dBase versions III, IV, and 5.0.
Driver Settings Collating Sequence -- Select the collating sequence you want to use. The collating sequence determines the sequence in which the fields are sorted.
Page Timeout -- Specifies the period of time, in tenths of a second, that a page (if not used) remains in the buffer before being removed.

Microsoft Access ODBC options

ColdFusion ODBC options for Microsoft Access data sources are described in the following table.

Microsoft Access ODBC Options
Option Description
Data Source Name A name for your ODBC data source.
Description Descriptive information about the data source.
Database File Click the Browse button to select a database file for a file-based ODBC data source.
System Database Specify a database file to make it accessible to the system or any user, rather than the local user. Note that Access data sources created with ColdFusion and specified as a Database File are automatically created as System Databases.
Driver Settings Page Timeout -- The length of time in milliseconds before a request for a ColdFusion page times out.
Buffer Size -- The total number of bytes ColdFusion uses to cache application pages. To optimize ColdFusion performance, enter a value.
Default Login A username/password combination ColdFusion uses to access the data source. If your ODBC data source requires a username or password, enter them here. To verify your data source, you need to enter login information here.

Microsoft Excel ODBC options

ColdFusion ODBC options for Microsoft Excel data sources are described in the following table.

Microsoft Excel ODBC Options
Option Description
Data Source Name A name for your ODBC data source.
Description Descriptive information about the data source.
Workbook/Directory The path and filename of the Excel workbook you want to use as the ODBC data source.
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 Rows to Scan -- The number of rows to scan to determine the data type of each column. The data type is determined given the maximum number of kinds of data found. If data is encountered that does not match the data type guessed for the column, the data type will be returned as a NULL value. Enter a number from 1 to 16 for the rows to scan. The value defaults to 8; if it is set to 0, all rows are scanned. A number outside the limit will return an error.

Microsoft Text ODBC options

ColdFusion ODBC options for Microsoft Excel data sources are described in the following table.

Microsoft Text ODBC Options
Option Description
Data Source Name A name for your ODBC data source.
Description Descriptive information about the data source.
Database Directory The directory where the text files are found.
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.


BackUp LevelNext

allaire

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