Adobe
Sign in Privacy My Adobe

ColdFusion MX: Configuring the IBM Informix JDBC Driver

Adobe Community Help


Products Affected

Contact support

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:



    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

Keywords: tn_19171

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy

Products

Download

Support & Learning

Buy

Company

Choose your region

Copyright © 2013 Adobe Systems Incorporated. All rights reserved.

Terms of Use | Privacy | Cookies

Reviewed by TRUSTe: site privacy statement