BackUp LevelNext

Configuring ODBC Data Sources for Solaris

ColdFusion Application Server for Solaris (Enterprise edition) supports ODBC 3.0. Intersolv documentation on the ODBC 3.0 drivers can be found in:

<installdir>/odbc/doc/odbchelp.pdf

This is an Adobe Acrobat file. You can download the Acrobat reader from the Adobe Acrobat web site, http://www.adobe.com.

The following drivers are available:

Solaris ODBC Drivers and Data Sources
Type Supports
dBase/FoxPro dBase IV and V files, and FoxPro files version 3.0
IBM DB2/6000 DB2/6000, DB2 v.5
INFORMIX INFORMIX 7.x or 9.x via INFORMIX-Connect 9.13
OpenIngres CA-OpenIngres 1.x, 2.x
Oracle Oracle 7.x and 8
Sybase 11 Sybase driver for System 11 clients (threaded)
Text ASCII text files

Configuring data sources for ColdFusion involves modifying the <installdir>/odbc/odbc.ini file. The odbc.ini file provides a means for mapping a data source name (DSN) to a particular ODBC driver. The ColdFusion Administrator can make these changes via a web browser based facility. In addition, this facility provides an interface to change ColdFusion specific settings for a data source, such as login and timeout info.

To add a data source for ColdFusion:

  1. Open the ColdFusion Administrator.
  2. Click the Data Sources label.
  3. Enter the name of the Data Source you want to add and select the appropriate driver from the pull-down list.

    When naming a ColdFusion data source, do not use the following names: Registry or Cookie.

  4. Click the Add button.
  5. Enter the ODBC options you want, such as the database you want to use, and a description of the data source and click Create.
  6. To set any environment variables your database client library may require, edit the ColdFusion start script found in <installdir>/coldfusion/bin.

For information about particular database drivers, refer to the Intersolv ODBC documentation, distributed as an Acrobat file in:

<installdir>/coldfusion/odbc/doc/odbchelp.pdf

BackUp LevelNext

allaire

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