Informix
| IMPORTANT INFORMATION |
Support to version 7.31 was interrupted by the manufacturer on 30/09/2009. Thus, it is recommended that you obtain a more recent version because from this date on approval with Microsiga Protheus will be discontinued in 6 months by TOTVS. Procedures are approved with Informix. |
| Windows Environment - ODBC Configuration |
| The connection made by TOTVSDBAccess to use Informix Database is performed through an ODBC Driver, which must be configured in the device where TOTVSDBAccess is installed. By configuring the connection through ODBC, some parameters of this configuration determine the database behavior. These parameters must be configured to fit the behavior expected by TOTVSDBAccess and by ERP application, since they will use this connection. ODBC driver configuration for Informix has some configuration tabs (General, Connection, Environment, Advanced, and About... ). The important points of these settings are: Environment - Cursor Behavior  The default value of this parameter is 0-Close. This parameter defines the database behavior regarding the automatic cursor closing (Queries) when a "commit work" or "rollback work" is performed in a transaction. Microsiga Protheus and TOTVSDBAccess do not expect any automatic cursor closing by confirming or aborting a transaction. Thus, Cursor Behavior must be configured with 1-Preserve for the correct operation of TOTVSDBAccess and Microsiga Protheus applications with Informix database. If this configuration is not adjusted, errors can be occurred and Microsiga Protheus applications may not work properly: database search failure, cursors ended with EOF() before returning all lines, and Stored Procedure call and execution failure. In these cases, the following errors are registered in TOTVSDBAccess LOG, in Fetch operations: Error : -11060 (37000) - [Informix][Informix ODBC Driver]General error. ( From tODBCStatement::Fetch ) Error : 0 (S1010) - [Microsoft][ODBC Driver Manager] Function sequence error ( From tODBCStatement::Fetch ) |
| Linux Environment - ODBC.ini Configuration for TOTVSDbAccess |
| ODBC.INI file is in the root directory (cd/root). [ODBC] Trace=0 TraceFile=/tmp/odbctrace.out InstallDir=/usr/informix [nomeconexao] Database= Servername= CursorBehavior=1 |
| Caption | |
  | Discontinued or not approved by the manufacturer and supported by TOTVS. |
| | Discontinued or not approved by the manufacturer and by TOTVS. |
 | In process of discontinuation by the manufacturer and supported by TOTVS. |
 | Approved by the manufacturer. |
| | Approved by the manufacturer and by TOTVS. |
| O.S. | Informix 7.31 | Informix 9.21 | Informix 9.30 | Informix 9.40 | Informix 10 | Informix 11.5 |
| Windows 2000 Server | | | | | | |
| Windows 2003 (X86) | | | | | | |
| Windows 2003 (X86_64) | | | | | | |
| Windows 2008 (X86) | | | | | | |
| Windows 2008 (X86_64) | | | | | | |
| Suse SLES8 (X86) | | | | | | |
| Suse SLES8 (X86_64) | | | | | | |
| Suse SLES8 (Itanium) | | | | | | |
| Suse SLES9 (X86) | | | | | | |
| Suse SLES9 (X86_64) | | | | | | |
| Suse SLES10 (X86) | | | | | | |
| Suse SLES10 (X86_64) | | | | | | |
| RedHat 2.1 AS / ES (X86) | | | | | | |
| RedHat 2.1 AS / ES (X86_64) | | | | | | |
| RedHat 2.1 AS / ES (Itanium) | | | | | | |
| RedHat 3 ES (X86) | | | | | | |
| RedHat 3 ES (X86_64) | | | | | | |
| RedHat 3 ES (Itanium) | | | | | | |
| RedHat 4.6 ES (X86) | | | | | | |
| RedHat 4.6 ES (X86_64) | | | | | | |
| RedHat 5.1 ES (X86) | | | | | | |
| RedHat 5.1 ES (X86_64) | | | | | | |
| Solaris 6 | | | | | | |
| Solaris 7 | | | | | | |
| Solaris 8 | | | | | | |
| Solaris 9 | | | | | | |
| Solaris 10 | | | | | | |
| IBM AIX 4.3.3 (X86) | | | | | | |
| IBM AIX 5.1.0 (X86) | | | | | | |
| IBM AIX 5.1.0 (X86_64) | | | | | | |
| IBM AIX 5L 5.2 | | | | | | |
| IBM AIX 5L 5.3 | | | | | | |
| IBM AIX 6.1 | | | | | | |