Database Name The name of the database to which you want to connect. Make the following entry at the bottom of the file:. Adding the ODBC data source. To install the client software: Stop and Restart the Allaire ColdFusion 4. Choose Custom Choose the Client connectivity:
|Date Added:||16 April 2005|
|File Size:||17.68 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
By default, ColdFusion will install to run under the system account. Enable scrollable cursors — Determines whether the driver provides scrollable cursors. Installing Informix client software.
There should also be a variable called “Path” which should include the path to the Informix bin directory. Select the System DSN tab and click the add button. Cursors Preserve cursors at the end of each transaction — Determines whether cursors will be preserved or closed onformix-cli the end of each transaction. Let’s assume that the demo database that ships with Informix is installed on the Informix server and the name of the demo database is “stores7. This information applies to both native driver connectivity as well as ODBC.
Modifying the services file entry. Once the client software is configured, you need to verify the data source in ColdFusion to be sure everything is configured properly. Demo Data Database Name: You can use this in a ColdFusion application. If verification fails, check the system environment variables.
This entry is needed for the client software to find the instance of the Informix service on our network. Once you’ve reconfigured the account under which ColdFusion runs, you can retry verification of the data source in the ColdFusion Administrator. To check the system environment variables: After typing in the values, click the Set button.
IBM Informix 32 bit ODBC setup for Microsoft Windows – United States
Default Database The name of the database to which you want to connect by default. Note Check with your system administrator for the name of the service.
Configure the Informix Setnet32 utility as follows: 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. Reenter the Password and Change Password values.
Informix Connection String Samples –
Make the following entry at the bottom of the file:. Check with your dba or network administrator for database server name, host name, correct protocol, and service name. If you are having trouble accessing a data source, and the data source resides on a different machine, you may want to try having ColdFusion run under an administrator account on the Web server.
Description Descriptive information about the data source. If you are having trouble accessing a data source, and the data source resides on a different machine, you may want to try having ColdFusion run under an administrator account on the Web server.
Connecting to Informix data sources
Enable Insert cursors — Determines whether the driver can use Insert cursors during parametrized inserts. Logon as administrator before performing the installation.
Make the following entry at the bottom of the file:. Make sure to choose a user name from the user list rather then typing it. You will need to uncompress, and untar this file into a separate subdirectory on your server.
To add the ODBC data source to your system: Database Name The name of the database to which you want to connect. The following setup information for Informix describes how to install and configure Informix client software for Windows and UNIX systems. You inforix-cli use this in a ColdFusion application.