Preparing to use the Informix
database
Before you define the database interface and connect to an Informix
database in PowerBuilder, follow these steps to prepare the database for
use:
-
Install and configure the required database server, network, and
client software. -
Install the native Informix IN9 or I10 database
interface. -
Verify that you can connect to the Informix server and database
outside PowerBuilder.
Step 1: Install and configure the database
server
You must install and configure the required database server,
network, and client software for Informix.
To install and configure the required database server, network,
and client software:
-
Make sure the Informix database server software and database
network software is installed and running on the server specified in
your database profile.You must obtain the database server and database network
software from Informix.For installation instructions, see your Informix
documentation. -
Install the required Informix client software on each client
computer on which PowerBuilder is installed.Install Informix Connect or the Informix Client SDK (which
includes Informix Connect).You must obtain the Informix client software from IBM. Make sure
the version of the client software you install supports all of the
following:The operating system running on the client computer
The version of the database that you want to access
The version of PowerBuilder that you are running
For installation instructions, see your Informix
documentation. -
Make sure the Informix client software is properly configured so
that you can connect to the Informix database server at your
site.Run the SetNet32 utility to configure the client registry
settings. When you configure Informix Connect client software, it
creates a registry entry in
HKEY_LOCAL_MACHINESoftwareInformixSqlHosts. The registry entry
contains parameters that define your network configuration, network
protocol, and environment variables. If you omit these values from the
database profile when you define the native Informix database
interface, they default to the values specified in the registry
entry.For instructions on configuring your Informix client software,
see your Informix documentation. -
If required by your operating system, make sure the directory
containing the Informix client software is in your system path.
Step 2: Install the database
interface
If you install PowerBuilder using the PowerBuilder Installer (an online setup program), the native Informix database interface is automatically installed.
If you install PowerBuilder using the downloaded installation package (an offline setup program), select Native Database Interfaces | Informix interface from the list of components.
Step 3: Verify the
connection
Make sure you can connect to the Informix server and database you
want to access from outside PowerBuilder.
To verify the connection, use any Windows-based utility (such as the
Informix ilogin.exe program) that connects to the database. When
connecting, be sure to specify the same parameters you plan to use in your
PowerBuilder database profile to access the database.
For instructions on using ilogin.exe, see your Informix
documentation.