To build Desktop Informix sample database tables

The CONNX Desktop Informix module enables access to Informix database objects through the Informix driver. See the section on the CONNX Informix Module in the CONNX User Reference Guide, either online, on the CD-ROM, or in hard copy, for more information on the text boxes required to import Informix database tables.

For multiple client connections to Informix via ODBC through a single CONNX Data Dictionary, either the SQL Server data source name must be a file-based DSN and installed on a shared network server, or the same DSN must be configured on each client computer accessing the sample database tables.

  1. During installation, click Yes to install sample database tables, or click the Start button, and then point to All Programs. Point to CONNX Sample Databases, and then click Build Desktop Informix Sample Data. Select the ODBC Provider option under Logon Information in the Informix Sample Database Logon dialog box.

    image\Image6.gif
     

  2. Click the Select DSN button. The Select ODBC DSN dialog box appears. Select a DSN for the data source in which the sample tables are to be entered.

    image\Image7.gif
     

  3. Click the OK button. The Informix Sample Database Logon dialog box appears. Type a user name and password for the ODBC provider.

  4. Click the OK button. The samples are installed in the selected data source table and appear in the CONNX Data Dictionary Manager window.

Note: Informix catalogs are not supported by the CONNX Desktop Informix module.