Connect to Informix (FireDAC)
Go Up to Database Connectivity (FireDAC)
This topic describes how to connect to Informix database.
Contents
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:
- Drop a TFDPhysInfxDriverLink component from the "FireDAC Links" palette page.
- Or include the FireDAC.Phys.Infx unit in the uses clause.
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 (see Defining Connection (FireDAC) for details).
DriverID=Infx
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 |
WriteTimeout | Specifies the number of seconds that determines how long the application will attempt to send data to the server before the Informix ODBC driver closes connection (0 specifies an infinite wait).The default value is 0. | 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 |
StringFormat |
Defines how to represent String values:
|
Unicode |
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 |
TxSupported | Specifies if the Informix database supports SQL transactions or not.
|
Choose |
TxRetainLocks | Specifies whether the RETAIN UPDATE LOCK option is enabled or not.
|
Yes |
TxLastCommitted | Specifies whether the LAST COMMITTED option is enabled or not. It is useful in contexts where an application attempts to read a row locked by another session. If this option is enabled, then, the database server returns the most recently committed version of the row, rather than wait for the lock to be released.
|
Yes |
Use Cases
- Connect to Informix database server:
DriverID=Infx Server=ol_informix1170 Database=sysuser User_Name=informix Password=mypwd MetaDefSchema=informix