This TechNote describes how to configure Macromedia ColdFusion MX Server configuration to use the IBM Informix JDBC driver to connect to Informix 7.3 or 9 databases.

Configuring ColdFusion MX to use the IBM Informix JDBC driver

1. Download and install the Informix JDBC driver from the IBM website.
2. In the ColdFusion Administrator, click on the "Java and JVM" page. Add the directory in which the ifxjdbc.jar file resides to the Class Path field.
   
   Note: Use a comma (,) to separate class paths when this field contains multiple values.
3. Click Submit Changes to update Java and JVM Settings for ColdFusion MX.
4. Restart the ColdFusion MX Application Server service.
   
   On Unix platforms, from the cf_root/runtime/bin directory, run:
   
   coldfusion restart
5. Use the ColdFusion MX Administrator Data Source page to add a new data source for the Informix JDBC Driver.
   
   For example:
   
6. 
   
   1. Name the data source inftest when it will connect to an Informix database named inftest.
   2. Select Other in the driver field to tell ColdFusion you will describe another type of driver.
   3. Click Add to add the data source and display the default driver window for this driver.
7. Enter the following in the JDBC URL field:
   
   jdbc:informix-sqli://10.1.123.23:1525/test:informixserver=qa_tcp
   
   Where 10.1.123.23 is the IP Address of the physical Informix server.
   
   Where 1525 is the port number for the data source connection.
   
   Where test is the Informix database name.
   
   Where qa_tcp is the informixserver variable defined on the Informix database server machine.
   
   Note: The information in this field is case-sensitive.
8. Enter the following in the Driver Class field:
   
   com.informix.jdbc.IfxDriver
   
   Note: The information in this field is case-sensitive.
9. Enter a valid username and password in the Username and Password fields.
   
   Where the username and password are defined as user account information on the database server.
10. (Optional) Enter the name of the driver in the Driver Name field.
11. Click submit to apply the changes to the data source.

Additional Information

• ColdFusion MX: Trailing space in Driver Class field causes data source verification failure (TechNote tn_18612)
• ColdFusion MX support for JDBC drivers not shipped with ColdFusion (TechNote tn_18593)

Products affected