MACROMEDIA COLDFUSION 5-ADVANCED ADMINISTRATION, Manual

Page: 48 / 372

30 Chapter 1 Advanced Data Source Management
Configuring Informix SETNET32 settings
After you install the client software, you must configure your workstation to connect
to the Informix databases. The following example assumes that the demo database
that ships with Informix is installed on the Informix server and the name of the demo
database is “stores7.” Using the Start button in the Windows taskbar, go to Programs/
Informix-CLI 32 and select Informix Setnet 32.
Configure the Informix Setnet32 utility as follows:
•
Host Information:
Current Host = ts_informix
Username = informix
Password = informix
After you enter the values, click the Apply button.
•
Server Information:
Informix Server = ol_ts_informix
Hostname = ts_informix
Protocol = olsoctcp
Service Name = turbo
After you enter the values, click the Apply button.
•
Environment:
INFORMIXDIR=C:\PROGRAM FILES\INFORMIX
INFORMIXSERVER=ol_ts_informix
INFORMIXSQLHOSTS=\\TS_INFORMIX
After you enter the values, click the Set button.
Now you must create an ODBC data source using the ODBC Administrator in the
Windows ODBC Control Panel applet.
Adding the ODBC data source
Follow these steps to add the ODBC data source to your system.
To add the ODBC data source to your system:
1 Run the ODBC administrator in Control Panel.
2 Select the System DSN tab and click the Add button.
3 From the list of installed drivers, select Informix-CLI 2.5 (32 bit).
4 Enter the following information in the ODBC INFORMIX 7.2 Driver Setup dialog
box:
Data Source Name: Inf_ol7
Description: Demo Data
Database Name: stores7
Click the advanced button
Database List:
Default User Name: informix
Host Name: ts_informix
Service Name: turbo
Server Name: ol_ts_informix