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_MACHINE\Software\Informix\SqlHosts. 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.
