User Guide

Connecting to Informix Databases 31
Protocol Type: olsoctcp
Yield Proc: 1 - None
Cursor Behavior: 0 - Close
Enable Scrollable Cursors: 0 - Disabled
Get DB List From Informix: 1 - Yes
Now you have an Informix ODBC data source. You can use this in a ColdFusion
application. It is important to note that you must provide a username and password
in the ColdFusion
cfquery tag.
Verifying the Informix data source
After you configure the client software, verify the Inf_ol7 data source, as described in
Installing and Configuring ColdFusion Server, to make sure it is configured properly.
If verification fails, check the system environment variables.
To check the system environment variables:
1 Open the System Control Panel/system and click the Environment tab. In the
System Variables dialog box, the variable called InformixDir should point to the
Informix folder (for example,
C:\program files\informix). If it does not exist,
add an InformixDir variable.
There should also be a variable called Path, which should include the path to the
Informix bin directory. If it does not, then modify the Path variable to include it.
2 After adding these variables, restart the system.
If you are having trouble accessing a data source, and the data source resides on a
different machine, try running ColdFusion under an administrator account on the
Web server.
Also, make sure that all ColdFusion services are running under a specific account
(“This Account”, in the Control Panel) instead of the default system account. By
default, ColdFusion installs to run under the system account.
To change the Windows NT account that ColdFusion uses:
1Select Start > Settings > Control Panel > Services > Cold Fusion Application
Server > StartUp.
2 In the Log On As section, select This Account and browse to an administrator
account. Enter username and password values.
3 Reenter the Password and Change Password values.
4 Stop and Restart the ColdFusion Application Server service.
5 Repeat steps 1 through 4 for the ColdFusion Executive and ColdFusion IDE
services as well.
After you reconfigure the account under which ColdFusion runs, you can retry
verification of the data source in the ColdFusion Administrator.