Connect to Informix (FireDAC)

From Appmethod Topics
Jump to: navigation, search

Go Up to Database Connectivity (FireDAC)

This topic describes how to connect to Informix database.

Supported Versions

The FireDAC native driver supports Informix version 8 and later.

Windows Client Software

FireDAC requires the IBM INFORMIX ODBC DRIVER x86 or IBM INFORMIX ODBC DRIVER (64-bit) x64 ODBC driver to be installed on the workstation. These drivers are part of the Informix Client SDK, and they can be downloaded from the following locations:

After installing, run <client>\bin\setnet32 to register the database servers.

If the Informix ODBC driver has not been properly installed, an exception is raised when you try to connect:

[FireDAC][Phys][ODBC][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Driver Linkage

To link the driver:

Connection Definition Parameters

An Informix database server must be registered on the client workstation using "<client>\bin\setnet32" utility. To connect to the registered database, an application should specify its name using the Server parameter. Also specify Database, User_Name and Password parameters.


Parameter Description Example value
Server Registered database server name. ol_informix1170
Database Database name. sysuser
User_Name The Informix user name. informix
Password The DB user password. Note that passwords with both '{' and '}' are not supported. i
ReadTimeout Controls the amount of time, in seconds, before an application times out while attempting to read from a connection (0 specifies an infinite wait). For example, when fetching rows. 30
LoginTimeout Controls the amount of time, in seconds, before an application times out while attempting to establish a connection (0 specifies an infinite wait). 30
CharacterSet Specifies client locale (CLOC ODBC parameter). en_US.CP1252

Defines how to represent String values:

  • ANSI -- always represents as ftString / ftMemo (default).
  • Unicode -- always represents as ftWideString / ftWideMemo.
ODBCAdvanced Allows you to specify any other additional ODBC connection parameter value. The default value is "IGNOREWARNINGS=1".
MetaDefSchema Default schema name. The design time code excludes the schema name from the object name if it is equal to MetaDefSchema. informix

Usage Cases

  • Connect to Informix database server:

See Also