Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
Informix® ODBC Driver GuideThe Informix® ODBC Driver Programmer's Manual serves as a user guide and reference for Informix® ODBC Driver, which is the Informix® implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
Overview of HCL Informix® ODBC DriverThese topics introduce the Informix® ODBC Driver and describe its advantages and architecture. The topics also describe conformance, isolation and lock levels, libraries, and environment variables.
HCL Informix® ODBC Driver componentsInformix® ODBC Driver includes the four components.
Environment variablesThere are four environment variables that you must set for the driver.
Set environment variables on UNIX™If you set the environment variables at the command line, you must reset them whenever you log on to your system. If you set the environment variables in a file, they are set automatically when you log on to your system.

Set environment variables on UNIX

If you set the environment variables at the command line, you must reset them whenever you log on to your system. If you set the environment variables in a file, they are set automatically when you log on to your system.

Informix® ODBC Driver provides a sample setup file called setup.odbc in $INFORMIXDIR/etc. You can use this file to set environment variables for the driver. The following list describes the environment variables that are in setup.odbc.

INFORMIXDIR: Full path of the directory where Informix Client Software Development Kit is installed.
INFORMIXSQLHOSTS: This value is optional. It specifies the directory that contains sqlhosts. By default, sqlhosts is in $INFORMIXDIR/etc. Set INFORMIXSQLHOSTS if you want sqlhosts to be in a different directory.
ODBCINI: This value is optional. You can use it to specify an alternative location for the odbc.ini file. The default location is your home directory.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.