informix client products installation guide for microsoft windows environments

Informix ClientProducts

Installation Guide

for Microsoft Windows Environments

Version 2.0February 1998Part No. 000-5024

ii Informix Client Produ

Published by INFORMIX® Press Informix Software, Inc.4100 Bohannon DriveMenlo Park, CA 94025

Copyright 1981-1998 by Informix Software, Inc., provided that portions may be copyrighted by third parties,as set forth in documentation. All rights reserved.

The following are worldwide trademarks of Informix Software, Inc., or its subsidiaries, registered in theUnited States of America as indicated by “®,” and in numerous other countries worldwide:

INFORMIX; the Informix logo; Informix Dynamic Server;Informix Dynamic Server, Workgroup Edition;Informix Dynamic Server with Extended Parallel Option;Informix Dynamic Server with Universal Data Option; Informix Illustra Server; DataBlade

All other marks or symbols are registered trademarks or trademarks of their respective owners.

RESTRICTED RIGHTS/SPECIAL LICENSE RIGHTS

Software and documentation acquired with US Government funds are provided with rights as follows: (1) iffor civilian agency use, with Restricted Rights as defined in FAR 52.227-19; (2) if for Dept. of Defense use, withrights as restricted by vendor's standard license, unless superseded by negotiated vendor license as prescribedin DFAR 227.7202. Any whole or partial reproduction of software or documentation marked with this legendmust reproduce the legend.

cts Installation Guide for Microsoft Windows Environments

Table of Contents

Table ofContents

About This Manual . . . . . . . . . . . . . . . . . . 1Additional Documentation . . . . . . . . . . . . . . . 2Preparing to Install Informix Client Products . . . . . . . . . 3

System Requirements . . . . . . . . . . . . . . . 4Supported Configurations . . . . . . . . . . . . . . 6

Installing Informix Client Products . . . . . . . . . . . . 6Order of Installation . . . . . . . . . . . . . . . . 7Installation Options . . . . . . . . . . . . . . . . 9Using Setup to Install Client Products . . . . . . . . . . 13

Error Messages . . . . . . . . . . . . . . . . . . . 16Configuring Informix Client Products . . . . . . . . . . . 17

About Setnet32 . . . . . . . . . . . . . . . . . . 18Setting Environment Information . . . . . . . . . . . 19Setting Server Information . . . . . . . . . . . . . . 21Setting Host Information . . . . . . . . . . . . . . 23Creating a Windows NT Service . . . . . . . . . . . . 25

Environment Variables . . . . . . . . . . . . . . . . 26

Index

iv Inform
ix Client Products Installation Guide for Microsoft Windows Environments

About This ManualThis manual explains how to install the following products on computersthat run the Windows operating system:

■ INFORMIX-Client Software Developer’s Kit for Windows:

❑ INFORMIX-ESQL/C

❑ INFORMIX-Object Interface for C++

❑ INFORMIX-Object Interface for Java

❑ INFORMIX-Driver for JDBC

❑ INFORMIX-GLS

❑ INFORMIX-CLI, 32-bit version

❑ INTERSOLV DataDirect ODBC Driver

❑ LIBMI, client implementation

■ INFORMIX-Connect for Windows, Version 2.0:

❑ Runtime versions of the Client SDK components

■ DataBlade Developers Kit:

❑ BladeSmith

❑ BladePack

❑ BladeManager

❑ Schema Knowledge

❑ SQL Editor

■ Database Administration Kit, Version 2.0:

❑ BladeManager

❑ Schema Knowledge

❑ SQL Editor

Each package also includes the Setnet32 utility for configuring clientproducts, and may also include on-line help, example programs, and supportprograms.

Informix Client Products Installation Guide for Microsoft Windows Environments 1

Additional Documentation

INFORMIX-Client Software Developer’s Kit and INFORMIX-Connect alsoinclude Microsoft ODBC Driver Manager, which is required to useINFORMIX-CLI or INTERSOLV DataDirect ODBC Driver.

Additional DocumentationImportant: Your CD-ROM may have a readme.txt file in the root directory. Whenpresent, this file contains information that was available only after other documen-tation was complete. In particular, the readme.txt file may contain information thatyou should read before you install your Informix client product. You can open thereadme.txt file in any Windows text editor, such as Notepad.

The documentation set for Informix client products includes manuals andon-line notes for each of the components.

The manuals for each package are described in the following table.

Package Included Manuals

Client SDK One manual for each component, plus the SQLmanual set and other server manuals

Connect No additional manuals

DataBlade Developers Kit One manual for each component

Database Administration Kit One manual for each component

2 Informix Client Products Installation Guide for Microsoft Windows Environments

Preparing to Install Informix Client Products

Some components have on-line notes, located in the release\en_us\04e4subdirectory of your Informix installation directory. In addition, some on-line notes have icons in the program groups. On-line notes are described inthe following table.

In addition to on-line notes for component products, the client productsinstallation includes release notes and documentation notes. Thedocumentation notes are in the file CLNTDOC.TXT. The release notes are inthe file CLNTREL.TXT.

Preparing to Install Informix Client ProductsYou install Informix products for Windows environments with aninstallation program that copies files to your client computer.

You can install Informix products only as licensed by Informix. You cannottransfer software from one computer to another, or to another portion of yournetwork, without reregistration and the written consent of Informix.

These instructions assume that you are familiar with your computeroperating procedures and your Windows environment.

If you encounter problems, contact your Informix Technical Supportdepartment. In North America, call toll-free (800) 274-8184 or send a fax to(913) 599-8590. Outside North America, contact your distributor or thenearest Informix subsidiary.

On-Line File Purpose

Release notes Describe the following:

■ Feature differences from earlier versions of Informix productsand how these differences might affect current products

■ Information about known problems, their workarounds, andfixed bugs

Documentationnotes

Describe documentation errata or information obtained afterthe associated manual was printed

Machine notes(optional)

Describe any special actions required to configure and useInformix products on your computer’s operating system


System Requirements

System RequirementsThe following table outlines the system requirements for Informix clientproducts for Windows environments.

Providing a Database Server

Client SDK Version 2.0 and INFORMIX-Connect Version 2.0 can be used onclient computers connecting with Informix databases. See the on-line releasenotes for each client component for a list of compatible Informix servers.

The DataBlade Developers Kit and Database Administration Kit requireInformix Dynamic Server with Universal Data Option.

Providing a Protocol

Informix client products work with any TCP/IP protocol that complies withWindows Sockets 1.1.

You select a protocol through Setnet32. See “Setting Server Information” onpage 19 for instructions.

Supported Compilers

C and C++ applications should be compiled using Microsoft Visual C++version 5.0.

Requirement Windows 95 Windows NT

Hardware 80486 or highermicroprocessor

80486 or highermicroprocessor

Windows version Windows 95 Version 4.0

RAM 12 MB 16 MB

Hard-disk storage 20 MB(or less, depending on theproducts and componentsyou install)

20 MB(or less, depending on theproducts and componentsyou install)


System Requirements

Java applications should be compiled using JavaSoft JDK version 1.1.

Installing Microsoft ODBC Driver Manager

To use INFORMIX-CLI or INTERSOLV DataDirect ODBC Driver, you must firstinstall a Microsoft ODBC Driver Manager.

The Client SDK and INFORMIX-Connect products include two versions ofDriver Manager:

■ Driver Manager Version 2.5 is recommended if you useINFORMIX-CLI.

■ Driver Manager Version 3.0 is required if you use the INTERSOLVDataDirect ODBC Driver.

You can use a version of Driver Manager greater than Version 2.5 withINFORMIX-CLI, but some applications may experience errors if DriverManager Version 3.0 is installed. Therefore, Version 2.5 is recommended.

Driver Manager may already have been installed on your computer byanother product. You do not have to install a new Driver Manager unless youwant to use a different version.

Finding the Version of the Installed Driver Manager

To find out what version of Driver Manager is installed on your computer,double-click the ODBC icon in the Control Panel, then double-click the Abouttab to display the installed ODBC components.

If there is no About tab on the ODBC Control Panel, you have a DriverManager lower than Version 3.0. To find the specific version number, useWindows Explorer to browse your Windows system directory (SYSTEM onWindows 95 or SYSTEM32 on Windows NT). Select the odbc32.dll file andthen choose the Properties command from the File menu. Click the Versiontab to find the version number of the driver.

Installing Driver Manager

You can use the Informix Setup program to install Driver Manager.


Supported Configurations

If you want to install an older version of Driver Manager than is currentlyinstalled on your computer, first uninstall the newer version using theuninstall program for the package that installed it.

When you run Setup you must choose the Custom installation type and thenchoose the Driver Manager version you want to install. See “InstallingInformix Client Products” on page 6 for Setup instructions.

Supported ConfigurationsInformix client products use a two-process architecture that is suited forclient/server networks, which Figure 1 illustrates. Your database applicationruns as one process on a PC workstation and communicates across a networkwith a separate Informix database server process on a host computer.

Installing Informix Client ProductsTo install Informix client products, run the Setup program for each packagethat you wish to install. The Setup program allows you to choose whichcomponents of the package to install.

Figure 1Client/ServerArchitecture

Client PC

Host computer

Database

Storage disk

Networkconnection

Database server process

Database server

Clientapplication

Applicationtool process


Order of Installation

The following sections describe Informix client product installation options,how to install your software, and solutions to installation problems.

Order of InstallationInformix software products share some files, including runtime libraries,message files, and GLS files. If you install multiple products on the samecomputer, you must install them in the correct sequence, or in separatedirectories, so that shared files remain compatible.

■ Installing a database server and a client product on a computer

■ Installing a new version of Client SDK

■ Installing a new version of Connect

Installing a Database Server and a Client Product on a Computer

When you install Client SDK or Connect in the same directory as an Informixdatabase server, install the client product before you install the databaseserver.

Tip: In some cases, client products may be installed after the database server. Checkthe readme.txt file on the installation CD-ROM for installation dependencyinformation.

You can install a client product into a different directory from the databaseserver INFORMIXDIR. If you do this, before you execute a client application,you must set the value of the INFORMIXDIR environment variable to thedirectory where you installed the client product.

Installing a Newer Version of Client SDK

You can install a newer version of Client SDK in either of the following ways:

■ Install the new version into a different INFORMIXDIR from thecurrent version.

This leaves the runtime environment of current applicationsunchanged. New applications can use the new version of the ClientSDK.


Order of Installation

■ Install the new version into the same INFORMIXDIR as the currentlyinstalled version. Current applications will use the newer versions ofthe Informix runtime libraries, message files, and GLS files.

Current applications access most of the bug fixes and performanceenhancements offered by the new runtime environment. To benefitfrom all bug fixes and performance enhancements, or to access newfeatures, current applications must be recompiled using the newClient SDK.

Installing an older version of Client SDK into the same INFORMIXDIR of theexisting Client SDK is not supported.

Installing a Newer Version of Connect

You can install a newer version of Connect in either of the following ways:

■ Install the new Connect in a different INFORMIXDIR from the currentversion. This leaves the runtime version of the current versionunchanged.

■ Install the new Connect in the same INFORMIXDIR as the currentlyinstalled version, without replacing the existing runtime libraries.

Setup prompts you before replacing runtime libraries. When youchoose not to replace the runtime libraries, only GLS and messagefiles are replaced.

■ Install the new Connect in the same INFORMIXDIR as the currentlyinstalled version, replacing the existing runtime libraries.

When you choose to replace the runtime libraries, Setup savesexisting runtime libraries (.dll files) with an extension of .old, andinstalls the new runtime libraries, message files, and GLS files.

Current applications access most of the bug fixes and performanceenhancements offered by the new runtime environment. To benefitfrom all bug fixes and performance enhancements, or to access newfeatures, current applications must be recompiled using the newClient SDK.

Installing an older version of Connect into the same INFORMIXDIR of theexisting Connect is not supported.


Installation Options

Installation OptionsWhile running the Setup utility, you can select which components and sub-components to install. Subcomponents include on-line help and exampleprograms. The installation options are described in the following table.

The following sections describe the components of the Informix clientproducts.

Client SDK

The Client SDK allows you to develop and run client applications inWindows environments.

You must install the Client SDK to compile a client application. If you havealready compiled an application and you want to deploy it on one or moreother computers, you can install Connect on those computers instead.

Option Description

Typical Includes all components, on-line help, and examples.

Compact Includes all components without on-line help andexamples.

Custom You select the components and subcomponents to install.



The components of the Client SDK are described in the following table.

Component Description

Connect Runtime versions of INFORMIX-CLI, INTERSOLVDataDirect ODBC Driver, Object Interface for C++,ESQL/C, GLS, LIBMI, and Object Interface for Java.

ESQL/C An SQL embedded-language product used to createcustom C applications. For more information, see theINFORMIX-ESQL/C Programmer’s Manual and theINFORMIX-ESQL/C Programmer’s Supplement for MicrosoftWindows Environments.

INFORMIX-ObjectInterface for C++

A C++ interface to develop object-oriented client applica-tions for use with all Informix database servers, and client-side value objects for Dynamic Server with UD Option.For more information, see the INFORMIX-Object Interfacefor C++ Programmer’s Guide.

INFORMIX-ObjectInterface for Java

and

INFORMIX-Driver forJDBC

A library of Java classes and interfaces that allowsprogrammers to create client applications and applets.When used with Dynamic Server with UD Option, theinterface can also support value objects provided byDataBlade modules.

The Object Interface for Java also includes JDBC support.

The Object Interface for Java is located in the lib\javasubdirectory of the Informix installation directory.

For more information, see the INFORMIX-Object Interfacefor Java Programmer’s Guide.

INFORMIX-GLS An interface that allows Informix products to use differentlocales, which have defined conventions for a particularlanguage, culture, or code set. For more information, seethe INFORMIX-ESQL/C Programmer’s Supplement forMicrosoft Windows Environments and the INFORMIX-GLSProgrammer’s Manual.

(1 of 2)



Connect

Connect contains runtime versions of the Client SDK components, which aredescribed in the “Client SDK” section. The runtime versions allow you to runcompiled client applications in a Windows environment. If Client SDK isinstalled on a computer, it is not necessary to install Connect.

DataBlade Developers Kit

The DataBlade Developers Kit allows you to develop DataBlade modules forInformix Dynamic Server with Universal Data Option.

INFORMIX-CLI The call-level interface for Informix database servers. Itacts as the ODBC driver. INFORMIX-CLI Version 2.8complies with ODBC 2.5 and supports extended datatypes.

INTERSOLVDataDirect ODBCDriver

An ODBC driver that complies with ODBC 3.0. For moreinformation, see the INTERSOLV DataDirect ODBC DriverUser Guide for Informix Database Servers.

LIBMI, clientimplementation

A client-side implementation of the LIBMI C API,provided to ease migration of client applications from theInformix Illustra Server to Informix Dynamic Server withUniversal Data Option.


(2 of 2)



The components of the DataBlade Developers Kit are described in thefollowing table.

Database Administration Kit

The Database Administration Kit allows you to administer Dynamic Serverwith UD Option and DataBlade modules.

The components of the Database Administration Kit are BladeManager, SQLEditor, and Schema Knowledge, each of which is described in the “DataBladeDevelopers Kit” section.


BladeSmith A graphical user interface for defining and buildingDataBlade modules. It defines DataBlade module compo-nents and generates C and SQL source files and functionaltests. For more information, see the DataBlade Developers KitUser’s Guide.

BladePack A graphical user interface for packaging a DataBlademodule. It enforces a common installation strategy for allDataBlade modules and produces a package thatBladeManager can install. For more information, see theDataBlade Developers Kit User’s Guide.

BladeManager A graphical user interface for registering and managingDataBlade modules. For more information, see theBladeManager User’s Guide.

SQL Editor A utility that allows users to create and submit SQL queries.For more information, see Using the SQL Editor.

Schema Knowledge A graphical user interface that provides meta or schemainformation about Informix databases. Schema Knowledgeallows you to see the objects in the database in relation toother database objects, to view the detailed structures ofthese objects, and to quickly find the details on referencedobjects. For more information, see the Schema KnowledgeUser’s Guide.


Using Setup to Install Client Products

Using Setup to Install Client ProductsRun Setup to install each client product.

To install client products

1. Load the media for your client product into the CD-ROM drive.

2. Read the readme.txt file in the root directory of the CD-ROM. This filemay have information you need before you continue.

3. Start the Setup program. In the Run dialog box, or at the DOSprompt, type:

d:setup

Replace d: with the CD-ROM drive letter.

Press ENTER or click OK. A serial number dialog box appears.

4. In the Enter Serial# and Key dialog box, enter your serial number andkey. You can find the serial number and key on the Serial NumberCard you received with the product package.

Click Next. If this is the first Informix software installed on thiscomputer, a user registration dialog box appears. Otherwise, theInstallation Options dialog box appears (Figure 2).



5. In the User Registration Information dialog box, enter your username and company name. This information is for display purposesonly.

Click Next. An installation dialog box appears (Figure 2).

In the Installation Options dialog box, choose the installation typeand destination directory:

■ Installation type. The installation options (Typical, Compact,and Custom) are discussed in the section “Installation Options”on page 9.

■ Destination directory. The default installation directory isC:\INFORMIX. You can click Browse to invoke the browser tohelp you select an installation path.

Figure 2Installation Dialog Box


Choose the installation type.

< Back Next > Cancel

Destination DirectoryC:\INFORMIX Browse...

Typical

Compact

Custom

Program will be installed with the most commonoptions. Recommended for most users.

Program will be installed with the minimum requiredoptions.

You may choose the options you want to install.Recommended for advanced users.



Important: Setup sets the INFORMIXDIR environment variable to the destinationdirectory you choose. Informix software products are designed to be installed in asingle directory identified by this environment variable. If you install Informixproducts in different directories, only those in the directory identified by theINFORMIXDIR environment variable can run.

Click Next. If you choose Custom installation type, the Select Instal-lation Components dialog box appears. Otherwise, the Select Folderfor Informix Applications dialog box appears.

6. In the Select Installation Components dialog box (Figure 3), choosethe components and subcomponents you wish to install.

The disk-space requirements are listed next to each component andsubcomponent. Informix recommends that you install allcomponents.

When you have selected the components to install, click Next. TheSelect Folder for Informix Applications dialog box appears.

Figure 3Select Installation Components Dialog Box

Select Installation Components

Click to the left of a name to check or uncheck that item. Check any

< Back Next > Cancel

items you want to install. Uncheck any items you do not want toinstall.Components: Sub Components:

✔ ESQL/C SDK 2674 K ✔ ESQL/C Demos 64 K

DescriptionESQL/C Development System for WIN32.

Space Required: 22678 K Space Available: 503338 K

✔ Core Java API

✔ Java Documentation

✔ Java Examples

✔ CLI Demos

7104 K

10637 K

272 K

64 K


Error Messages

7. In the Select Folder for Informix Applications dialog box, choose thefolder where you want to store Informix applications and icons. Youcan accept the default (INFORMIX), choose another existing folder, orenter the name of a new folder to create.

Click Next. The Ready to Install Files dialog box appears.

8. In the Ready to Install Files dialog box, make sure the informationshown is correct. You cannot change any options on this screen;however, you can click Back to return to previous screens andchange installation options.

Click Next.

9. If Setup does not encounter errors during the installation procedure,it displays the Setup Complete dialog box to indicate that theinstallation is successful.

Click Finish to exit Setup.

After these steps are completed, Setup has copied the client product softwareto your computer, created the Setnet32 icon and other icons in the INFORMIXprogram folder, and created the INFORMIX subkey of the Windows Registry.

If Setup generates an error message, see “Error Messages” on page 15 forassistance in diagnosing the error.

Error MessagesOccasionally, you might experience some difficulty in the installationprocedures. If your product does not install correctly, check for the followingconditions:

■ Error Message. Invalid OS: Error

Problem. Your client computer has an unsupported operating system.

Solution. Use one of the supported operating systems:

❑ Windows NT 4.0

❑ Windows 95


Configuring Informix Client Products

■ Error Message. Invalid Processor: Error

Problem. Your computer might be too old to handle client productrequirements. Possible old microprocessors include an 8086, 8088,286, or 386.

Solution. Use a computer with an Intel 486 or higher microprocessor.

■ Error Message. Error: file reading error

Problem. The installation program is unable to read the media.

Solution. You might have loaded the media disk into the wrong diskdrive. Try the installation process again. If it continues to fail, youmight have hardware problems. Check your hardware. YourCD-ROM or floppy drive might be broken, defective, or dirty. Yourhard drive might be corrupted or disabled. If the hardware isworking correctly, the media might be corrupted and it might benecessary to obtain new media.

■ Error Message. Not enough disk space: Error

Problem. You might not have enough hard-disk storage on yourcomputer for the client product software.

Solution. Make more space available on the disk on which you wantto install the Informix product, or choose a new disk location for thesoftware. For the amount of disk space that the Informix softwarerequires for installation, refer to “System Requirements” on page 4.

■ Error Message. Warning: Invalid serial number and key

Problem. The product cannot be installed because the serial numberor key code is not valid.

Solution. You must reenter the serial information correctly to proceedwith the installation script. If the installation still fails, reload theproduct files from the media and repeat all subsequent steps.

Configuring Informix Client ProductsThis section describes how to complete the following configuration tasks:

■ Setting environment information

■ Setting server information

■ Setting host information


About Setnet32

■ Creating a Windows NT service

You use Setnet32 to perform most configuration tasks, including setting mostenvironment variables, and server and host information.

You may have component-specific environment variables to set. Seeindividual product documentation for details.

About Setnet32With the Setnet32 utility, you can set or modify environment variables andnetwork parameters that Informix products use at runtime. The variablesand network parameters are stored in the Windows system registry and arevalid for every Informix client product you install on the same computer.

The Setnet32 utility has the following four tabbed pages:

■ Environment allows you to set environment variables.

■ Server Information allows you to set database server networkinformation.

■ Host Information allows you to set your host computer and logininformation.

■ About Setnet32 provides information about the Setnet32 utility.

In addition, the following buttons are at the bottom of the Setnet32 window.

Setnet32 Button Purpose

OK Updates the Registry with the information that you haveentered and then exits Setnet32.

Cancel Cancels all work that you have not already saved with theApply button and exits from Setnet32.


Setting Environment Information

Setting Environment InformationTo obtain information about Informix products and the environment inwhich they run, client products need to access environment variables. Some ofthese environment variables are required, and others are optional.

For more information on environment variables, see “EnvironmentVariables” on page 24 and the Informix Guide to SQL: Reference included withyour Informix database server documentation.

The INFORMIX-GLS Programmer’s Manual describes the environmentvariables that you need for locales. ♦

Set your environment variables with the Environment tab of the Setnet32utility (Figure 4).

Apply Updates the Registry with the information that you haveentered, but does not exit.

Help Invokes Setnet32 on-line help.

? (What’s This) Provides context-sensitive help. Click the What’s This?button, near the right side of the title bar, and then click anydisplayed control to get context-sensitive help about thatcontrol. You can also click the right mouse button over acontrol to access context-sensitive help.

Press any key to dismiss the help window.

Setnet32 Button Purpose

GLS


Setting Environment Information

Figure 4Setnet32

Environment TabbedPage

Save to File ...

Informix Client/Server Environment

Informix Setnet32

DELIMIDENT=nESQLMF=FET_BUFF_SIZE=

GL_DATETIME=GL_DATE=

Clear

SetVariable Name

Edit Environment Variable Save/Load

Load from File ...

OK Cancel Apply Help

INFORMIXDIR=C:\INFORMIXINFORMIXSERVER=hawkINFORMIXSQLHOSTS=\\MYPCLANG=

About Setnet32Host InformationServer InformationEnvironment

LC_COLLATE=


Setting Server Information

The Environment tabbed page contains the following elements:

■ Informix Client/Server Environment list box

From this list, you can select an environment variable so that you canedit its value with the controls in the Edit Environment Variablegroup.

■ Edit Environment Variable group

Once you select an environment variable in the InformixClient/Server Environment list box, the environment variable nameappears above the Variable Name text box. You can enter a newvalue in the Variable Name text box, edit the existing value, or selecta value by clicking the down arrow. Click Clear to assign a null valueto that environment variable. Once you have made your change,click Set to save that value.

For some environment variables you can select a value from a list, forother variables you can either select or type a value, and for othersyou must type a value.

■ Save/Load group

❑ Click Load From File to load your environment variables andtheir values from a specific file. However, you cannot loadenvironment variables from a specific file unless the Setnet32utility has already created that file (use the Save To File optionto create a file).

❑ Click Save To File to save your environment variables and theirvalues to a specific file.

Setting Server InformationA client application connects to an Informix server running on a computerthat can be reached through the network. To establish the connection, you useSetnet32 to specify the location of the Informix server on the network and thenetwork communications protocol to use. You must obtain this informationfrom the administrator of the server you want to use.


Setting Server Information

Set database server parameters with the Server Information tabbed page(Figure 5).

The Server Information tabbed page contains the following elements:

■ Informix Server list box

From this list, you can select an existing Informix database server, oryou can type the name of a new database server.

■ Host Name list box

From this list, you can select the host computer with the databaseserver you want to use, or you can type the name of a new hostcomputer.

■ Protocol Name list box

From this list, select a network protocol from a list of protocolsprovided by the installation procedure.

■ Service Name text box

In this text box, specify the service name associated with a specificdatabase server. You can type either the service name or the portnumber assigned to the database server on the host computer. Youmust obtain this information from the database server administrator.

Figure 5Setnet32

Server InformationTabbed Page

Informix Setnet32

Delete Server

Informix Server


Host Name

Protocol Name

Service Name

hawk

eagle

olsotcp

hawk_service


Make Default Server


Setting Host Information

Important: If you enter a service name, it must be defined on the client computer inthe system32\drivers\etc\services file in the Windows installation directory. Theservice definition must match the definition on the database server host computer.

■ Make Default Server button

This button sets the INFORMIXSERVER environment variable to thename of the current server to make it the default database server.

■ Delete Server button

This button deletes the definition of a database server from theWindows registry. It also deletes the host name, protocol name, andservice name associated with that database server.

Setting Host InformationA client application can make connections only to a host computer that it canaccess through the network. You describe a connection to a host computerwith host parameters.

For more information on host parameters, see the connectivity chapter in theAdministrator’s Guide for your database server.

You set host parameters for a specific host with the Host Information tabbedpage of the Setnet32 utility (Figure 6).

Figure 6Setnet32

Host InformationTabbed Page

Delete Host

Current Host


User Name

Password Option

Password

eagle

zaneq

Password

*****


Informix Setnet32


Setting Host Information

The Host Information tabbed page contains the following elements:

■ Current Host list box

This list displays host computers previously defined in the currentWindows registry. From this list, you can select the name of a hostcomputer with which to establish a network connection, or you canedit or retype a name on the list to define a new host name.

■ User Name text box

This text box displays the user name for an account on the currentlyselected host computer. This text box accepts a value with amaximum length of 18 characters. The value is visible and casesensitive.

■ Password Option list box

From this list, you can select one of the following password options:

❑ Ask password at runtime

This option specifies that your application is to prompt the userfor a password.

For information about how to use the sqlauth() function toprompt for a password and verify it, see the INFORMIX-ESQL/CProgrammer’s Supplement for Microsoft Windows Environments.

❑ No password

This option specifies that the user account has no password.When the application opens a new database, that applicationdoes not send a password to the database server. If the hostcomputer of the database server requires a password, theconnection fails and an error results.

❑ Password

This option specifies that the user account has a password thatmatches the encrypted value that the Password text boxdisplays. When the application opens a new database, thedatabase server compares the password that the user enters withthe login password for the host computer of the database server.The two passwords must be identical for the database server togrant access to the database. If the passwords are not identical,the user cannot connect to that database server across a network.


Creating a Windows NT Service

■ Password text box

This text box, which the Password option activates, displays theencrypted value of the account password. This encrypted valuecorresponds to the password that is in the Windows registry. Whenthis text box is enabled, it accepts a password value with a maximumlength of 18 characters. The value is invisible, case sensitive, andcannot contain any spaces.

To enter a new password, place the cursor inside the Password textbox and type the new password. Asterisks (*) represent thecharacters as you type.

■ Delete Host button

This button deletes the name of the currently selected host computerfrom the Windows registry, as well as the user name, passwordoption, and password associated with that host computer.

Creating a Windows NT ServiceWindows NT services do not search for configuration information in theWindows registry hive where Setup and Setnet32 store client productsenvironment variables. To enable a client application to run as a Windows NTservice, you must copy the values from the HKEY_CURRENT_USER\Software\Informix registry hive of the informix user to the HKEY_USERS\.Default\Software registry hive. You can perform this manually or by usingthe regcopy utility.

To run the regcopy utility, log in as user informix or as another user that hasadministrator privileges and can run Informix software. The regcopy utilityis in the bin subdirectory of the Informix installation directory. Once you aredone, you can check the progress by reviewing the regcopy.log file located inthe %TEMP% directory. ♦

Windows NT


Environment Variables

Environment VariablesThe following table lists environment variables that Version 2.0 clientproducts support. When maximum, size is specified, the terminating nullcharacter is not included.

Environment Variable PurposePossible Values(Default Value)

CC8BITLEVEL Specifies how the C languagecompiler processes non-ASCII(8-bit and multibyte) characters.

See INFORMIX-GLSProgrammer’s Manual.(2)

CLIENT_LOCALE Specifies the locale that the clientapplication uses to performread/write operations thatinvolve the keyboard, display, file,or printer on the client computer.

Any valid locale specifier. SeeINFORMIX-GLSProgrammer’s Manual.(None)

COLLCHAR Specifies a collation sequence forcharacters. Provided for backwardcompatibility with NLS products.

See Informix Guide to SQL:Reference.

CONRETRY Specifies the maximum number ofadditional connection attemptsmade to a database server in thetime limit that CONTIME specifies.

Same as INFORMIXCONRETRY.

(1)

CONTIME Specifies the number of secondsan SQL CONNECT statementcontinues to try to establish aconnection before it generates anerror.

Same as INFORMIXCONTIME.

(15)

DB_LOCALE Specifies the locale of all thedatabases that a client applicationaccesses in a single connection (thedatabase locale).

Any valid locale name

DBALSBC When set to 1, enables compati-bility with ALS products.

0 or 1

(1 of 6)



DBANSIWARN When turned on (y), causes thepreprocessor to check for Informixextensions to ANSI-standard SQLsyntax at compile time, and causesan application to check forInformix extensions at runtime.

(n)

DBAPICODE Enables pre-7.2 systems that usenonstandard or rare code sets toaccess databases that store data ina standard code set. Maximumsize = 23 characters. Provided forbackward compatibility with NLS andALS products.

Usage and values depend onlanguage system. See NLS andALS documentation fordescriptions.

DBASCIIBC When set to 1, enables compati-bility with ASCII products.

0 or 1

DBCENTURY Specifies how to expand values oftwo-digit-year DATE andDATETIME values. P = pastcentury, R = present century,C = closest century.

P, R, or C.See Informix Guide to SQL:Reference.(R)

DBCODESET Specifies an Asian-locale code set.Overrides the code set thatDB_LOCALE specifies. Providedfor backward compatibility withVersion 4.x and 5.x ALS products.

Same values as ALSDBAPICODE.(“8859-1::” unless theinformix.rc file specifiesanother system-wide default)

DBCONNECT Specifies whether or not connec-tions are restricted.

1 or 3

DBCSCONV Controls code-set conversioninitialization. Maximum size iseight characters. Provided forbackward compatibility with ALSproducts.

1 or2:codesetname

See 5.0 ALS documentation.


(2 of 6)



DBCSOVERRIDE Forces the user-specifiedDB_LOCALE value to overridedefault restrictions on accessingdatabases with locales differentfrom DB_LOCALE. Provided forbackward compatibility withVersion 6.0 ALS database servers.

0 or 1

DBCSWIDTH Maximum number of displaybytes (1-2) and storage bytes (1-4)for the characters in up to threecode sets. Display and storagewidths are separated by commas;code sets are separated by colons.Maximum size of this field is,therefore, 11 characters. Providedfor backward compatibility with ALSproducts.

Example:1,1:2,3 means a display andstorage width of 1 byte forcharacter set 1; a displaywidth of 2 bytes and a storagewidth of 3 bytes for codeset 2.

DBDATE Specifies the end-user format forDATE values so that they canconform with various interna-tional date conventions. Providedfor backward compatibility with pre-7.2 products. Informix recommendsGL_DATE for 7.2 ESQL/Capplications.

(“MDY4”unless NLS variable LC_TIMEis activated)

DBFLTMASK Specifies the number of decimaldigits to use when storing aDECIMAL, SMALLFLOAT, orFLOAT data type in a characterbuffer.

0–16(16)

DBLANG Specifies the subdirectory of theInformix installation directorythat contains the product-specificmessage (.iem) files.

(\msg)


(3 of 6)



DBMONEY Specifies the end-user format forMONEY values so that they canconform with various interna-tional and local monetaryconventions.

($.,)

DBMONEYSCALE Specifies the total number of digitsand number of decimal digits formonetary values. Provided forbackward compatibility with ALSproducts.

DBNLS Specifies whether an applicationcan access NLS features. Providedfor backward compatibility withNLS products.

(n)

DBPATH Identifies the database servers thatcontain databases that the appli-cation accesses.

DBSS2 Maximum size is four characters.Provided for backward compati-bility with ALS products.

0x00–0xff or0–255

DBSS3 Maximum size is four characters.Provided for backward compati-bility with ALS products.

0x00–0xff or0–255

DBTEMP Specifies the directory on theclient computer that the clientprocessor uses to store temporaryfiles (also called swap files).

(\tmp)

DBTIME Specifies the end-user format forDATETIME values so that they canconform with various interna-tional date conventions. Providedfor backward compatibility withpre-7.2 products. Informix recom-mends GL_DATETIME for 7.2ESQL/C applications.

(%Y-%m-%d %H:%M:%S)


(4 of 6)


DELIMIDENT Indicates whether (y) or not (n) tointerpret strings in double quotesas delimited identifiers.

(n)

ESQLMF Indicates whether the ESQL/Cprocessor automatically invokesthe ESQL/C multibyte filter(value=1 and CC8BITLEVEL<3, ornot value=0).

See INFORMIX-GLSProgrammer’s Manual.

FET_BUF_SIZE Overrides the default size of thefetch buffer.

Any valid buffer size, inbytes.

(Default value depends onrow size.)

GL_DATE Specifies a customized end-userformat for DATE values.


GL_DATETIME Specifies a customized end-userformat for DATETIME values.


INFORMIXDIR Identifies the location of the clientprograms, library files, messagefiles, header files, and otherInformix software components.

(C:\INFORMIX)

INFORMIXSERVER Identifies the default databaseserver.

See INFORMIX-ESQL/CProgrammer’s Supplement forMicrosoft WindowsEnvironments.

INFORMIXSQLHOSTS Specifies the name of thecomputer on which the centralregistry resides.

See INFORMIX-ESQL/CProgrammer’s Supplement forMicrosoft WindowsEnvironments.

LANG Specifies the languageenvironment (called a locale) for anNLS database that an applicationaccesses. Provided for backwardcompatibility with NLS products.

(C)


(5 of 6)


In addition, there is a set of environment variables you can use with thefunction call ifx_putenv to override the information entered in the ServerInformation and Host Information tabbed pages of Setnet32. To use theseenvironment variables, you must set the INFORMIXSERVER environmentvariable to a valid server name. Overrides only affect that server.

LC_COLLATE Specifies a collation or sortsequence for data in NCHAR andNVARCHAR columns of an NLSdatabase. Provided for backwardcompatibility with NLS products.


(value that LANG specifies)

LC_CTYPE Specifies character attributes suchas character classification and caseconversion of regular expressionsfor data in NCHAR andNVARCHAR columns of an NLSdatabase. Provided for backwardcompatibility with NLS products.



LC_MONETARY Specifies the end-user format forMONEY values in an NLS database.Provided for backward compati-bility with NLS products.


(value that LANGspecifies)

LC_NUMERIC Specifies the end-user format fornumeric values in an NLSdatabase. Provided for backwardcompatibility with NLS products.



LC_TIME Specifies the end-user format forDATE and DATETIME values in anNLS database. Provided forbackward compatibility with NLSproducts




(6 of 6)



The environment variables are described in the following table.

See the INFORMIX-ESQL/C Programmer’s Supplement for Microsoft WindowsEnvironments for more information.

Environment Variable Overrides the Value For

WIN32HOST The HOST network parameter

WIN32USER The USER network parameter

WIN32PASS The PASSWORD network parameter

WIN32ASKPASSATCONNECT The PASSWORD OPTION network parameter

WIN32SERVICE The SERVICE network parameter

WIN32PROTOCOL The PROTOCOL network parameter


@

Index

O QCA B D E F G H I J K L M N P R S T U V W X Y Z

Index

BBladeManager 12BladePack 12BladeSmith 12

CCC8BITLEVEL environment

variable 25CLIENT_LOCALE environment

variable 25COLLCHAR environment

variable 25Configuring

information 6Informix products 17, 19the environment 19

Connectcomponent descriptions 11documentation for 2

Connectionsetting length of attempt 25setting number of retries 25

Copying the registry hive 24

DDatabase Administration Kit

component descriptions 12documentation for 2

Database locale, setting languagefeatures 29

Database serverdefault 29identifying 28

setting parameters 20DataBlade Developers Kit

component descriptions 11documentation for 2

DATE data type 27DATETIME data type 28DBALSBC environment

variable 25DBANSIWARN environment

variable 25DBAPICODE environment

variable 26DBASCIIBC environment

variable 26DBCENTURY environment

variable 26DBCONNECT environment

variable 26DBCSCONV environment

variable 26DBCSOVERRIDE environment

variable 26DBCSWIDTH environment

variable 27DBDATE environment variable 27DBFLTMASK environment

variable 27DBLANG environment variable 27DBMONEY environment

variable 27DBMONEYSCALE environment

variable 27DBNLS environment variable 28DBPATH environment variable 28DBSS2 environment variable 28DBSS3 environment variable 28DBTEMP environment variable 28

@O QCA B D E F G H I J K L M N P R S T U V W X Y Z

DBTIME environment variable 28DB_LOCALE environment

variable 25DELIMIDENT environment

variable 28Delimited identifier 28Documentation notes, location of 3

EEnterprise Client Software

Developer’s Kitcomponent descriptions 9documentation for 2

Environment configuration 19Environment variable

CC8BITLEVEL 25CLIENT_LOCALE 25COLLCHAR 25DBALSBC 25DBANSIWARN 25DBAPICODE 26DBASCIIBC 26DBCENTURY 26DBCODESET 26DBCONNECT 26DBCSCONV 26DBCSOVERRIDE 26DBCSWIDTH 27DBDATE 27DBFLTMASK 27DBLANG 27DBMONEY 27DBMONEYSCALE 27DBNLS 28DBPATH 28DBSS2 28DBSS3 28DBTEMP 28DBTIME 28DB_LOCALE 25DELIMIDENT 28ESQLMF 28FET_BUF_SIZE 29GL_DATE 29GL_DATETIME 29INFORMIXCONRETRY 25INFORMIXCONTIME 25

INFORMIXDIR 29INFORMIXSERVER 29INFORMIXSQLHOSTS 29LANG 29LC_COLLATE 29LC_CTYPE 30LC_MONETARY 30LC_NUMERIC 30LC_TIME 30WIN32ASKPASSATCONNECT

31WIN32HOST 30WIN32PASS 30WIN32PROTOCOL 31WIN32SERVICE 31WIN32USER 30

Environment variables, setting 19ESQLMF environment variable 28ESQL/C 10

FFET_BUF_SIZE environment

variable 29File extension, .iem 27

GGL_DATE environment

variable 29GL_DATETIME environment

variable 29

HHost information, setting 22Host parameters 22

I.iem file extension 27INFORMIXCONRETRY

environment variable 25INFORMIXCONTIME

environment variable 25INFORMIXDIR

environment variable 29

INFORMIXSERVER environmentvariable 29

INFORMIXSQLHOSTSenvironment variable 29

Installationoptions 9order 7using Setup 13

Installation preparation 3Installation program 3

JJDBC, INFORMIX-Driver for 10

LLANG environment variable 29LC_COLLATE environment

variable 29LC_CTYPE environment

variable 30LC_MONETARY environment

variable 30LC_NUMERIC environment

variable 30LC_TIME environment variable 30

MMachine notes, location of 3Message file 27MONEY data type 27, 30

NNCHAR data type 29, 30Network parameters 30NLS environment

character attributes 30collation sequence 29database locale 29date and time formatting 30enabling 28monetary formatting 30numeric formatting 30regular expression searches 30


O QCA B D E F G H I J K L M N P R S T U V W X Y Z @

NVARCHAR data type 29, 30

OObject Interface for C++ 10Object Interface for Java 10ODBC 11ODBC Driver Manager

installing 5versions of 5

On-line notes, location of 3

PProcessor, storing temporary

files 28Product configuration 19Protocols 4

Rregcopy utility 24Release notes, location of 3

SSchema Knowledge 12Serial number and key 13Server parameters 20services file 22Setnet32 utility

buttons 18product configuration 18

Setting environment variables 19SQL Editor 12System requirements 4

TTCP/IP protocol 4

WWIN32ASKPASSATCONNECT

environment variable 31

WIN32HOST environmentvariable 30

WIN32PASS environmentvariable 30

WIN32PROTOCOL environmentvariable 31

WIN32SERVICE environmentvariable 31

WIN32USER environmentvariable 30

Windows registry 22, 23, 24copying current hive to default

hive 24Windows service 24

Index 3

informix client products installation guide for microsoft windows environments

Documents