User Guide

26 Chapter 1 Advanced Data Source Management
Connecting to Informix Databases
On Windows and UNIX, ColdFusion lets you access Informix databases using ODBC
and native drivers. ColdFusion 5 supports Informix 7.3 and later, including Informix
Dynamic Server.
If you install ColdFusion on a Windows server, you can configure an Informix
database as a ColdFusion data source using ODBC, OLE DB, or a native driver. For
information about using OLE DB with ColdFusion data sources, see “About OLE DB”
on page 4.
Informix for Windows requires version 2.5 or later of either the Informix-Connect for
Windows or the Informix Software Developer’s Kit for Windows. Informix for Solaris
and HP-UX requires Informix-Client Software Developer’s Kit version 2.5 or later for
UNIX.
Configuring Informix using ODBC
This configuration is now available on all platforms except Linux, which only
supports the Informix Dynamic Server. The following table describes ColdFusion
options for the MERANT Informix 7.x/9.x ODBC driver. You set these options when
you configure a ColdFusion data source.
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.
Host Name • The name of the machine on which the Informix server
resides.
• Use Informix registry for Logon ID and
Password Determines whether the server reads the
Logon ID and Password directly from the Informix
registry.
Server Port Number
(Informix Dynamic
ODBC Server Driver
only)
The number of the server port. This will match the number
entered in the services file for the Informix server.
Service (Informix 7.x/
9.x Driver only)
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.
Server Name The name of the Informix server as it appears in the sqlhosts
file.
Protocol (Informix 7.x/
9.x Driver only)
The network protocol.