User Guide

Chapter 4: Managing Data Sources 111
Connecting to Informix data sources
Connections to Informix databases are supported through ODBC on both Windows
and UNIX operating systems. On Windows, ColdFusion uses native drivers and on
UNIX, ColdFusion uses both native and ODBC drivers to connect to Informix
databases. ColdFusion 4.5 supports Informix 7.3 and higher.
Configuring Informix Options (Windows)
If ColdFusion Server Enterprise edition is installed on a Windows NT server, you can
configure Informix ColdFusion data sources using a native driver.
Native Driver: Informix 7.3 (Windows)
The following table describes ColdFusion options for the DB2 Universal Database 5.2/
6.1 native driver. You set these options when you configure a ColdFusion data source.
See “Adding Data Sources for ColdFusion” on page 82 for more information about
adding data sources to ColdFusion.
Informix Native Driver Options
Option Description
Data Source Name A name for your data source.
Description Descriptive information about the data source.
Default Database The name of the database to which you want to connect by
default.
Server The name of the INFORMIX server, including the full path.
Host The name of the machine on which the INFORMIX server resides.
Service The network services file. On Windows NT, the services file is
located in c:\winnt40\system32\drivers\etc. On UNIX, the file is
located in /etc
Protocol The network protocol.
Client Locale Specifies the language, territory, and code set that the client
application (ColdFusion) uses to perform operations that read or
write to the database.
Database Locale Specifies the language, territory, and code set that the INFORMIX
server needs to interpret locale-sensitive data types.