#INFORMIX ODBC OPTIONS UPDATE#
The RETAIN UPDATE LOCK option is not enabled. The RETAIN UPDATE LOCK option is enabled, which means that the database server retains the update lock until the end of the transaction. Specifies whether the RETAIN UPDATE LOCK option is enabled or not.
#INFORMIX ODBC OPTIONS DRIVER#
The ODBC driver queries the database, and sets the proper value for this parameter (depending on whether the Informix database supports transactions or not). The Informix database does not support transactions. The Informix database supports transactions. Specifies if the Informix database supports SQL transactions or not.
![informix odbc options informix odbc options](https://ccxguru.files.wordpress.com/2018/01/1.jpg)
The design time code excludes the schema name from the object name if it is equal to MetaDefSchema. The default value is "IGNOREWARNINGS=1".ĭefault schema name.
![informix odbc options informix odbc options](https://www.ibm.com/support/pages/system/files/support/swg/dmgtech.nsf/0/85256d51004c30c185256c99005d1e90/Content/0.E9C.gif)
![informix odbc options informix odbc options](https://www.synametrics.com/images/setNet.gif)
![informix odbc options informix odbc options](https://www.iri.com/blog/wp-content/uploads/2020/07/Informix-image4.png)
Or include the unit in the uses clause.Īn Informix database server must be registered on the client workstation using "\bin\setnet32" utility.Drop a TFDPhysInfxDriverLink component from the "FireDAC Links" palette page.Data source name not found and no default driver specified If the Informix ODBC driver has not been properly installed, an exception is raised when you try to connect:
#INFORMIX ODBC OPTIONS DRIVERS#
These drivers are part of the Informix Client SDK, and they can be downloaded from the following locations:Īfter installing, run \bin\setnet32 to register the database servers. The FireDAC native driver supports Informix version 8 and later.įireDAC requires the IBM INFORMIX ODBC DRIVER x86 or IBM INFORMIX ODBC DRIVER (64-bit) 圆4 ODBC driver to be installed on the workstation.