INFORMAÇÕES IMPORTANTES |
A versão 7.31 teve seu suporte descontinuado pelo fabricante na data 30/09/2009, recomendamos sua atualização para uma versão mais recente, pois a partir dessa data a homologação com o Protheus será descontinuada em 6 meses pela TOTVS.
Collation: EN_US.CP1252 (independente do S.O.) Está homologado o CLIENT 2 do Informix. Procedures são homologadas com Informix.
Consultar o site do fabricante para obter informações atualizadas sobre o release do Kernel: http://www-306.ibm.com/software/data/informix/pubs/roadmaps.html |
Ambiente Windows - Configuração de ODBC |
A conexão realizada pelo TOTVSDBAccess para utilização do Banco de Dados Informix, é realizada através de um Driver ODBC, que deve ser configurado no equipamento onde o TOTVSDBAccess está instalado.
Ao configurar a conexão via ODBC, alguns parâmetros desta configuração vão determinar o comportamento do banco de dados. Estes parâmetros devem ser configurados para se adequar ao comportamento esperado pelo TOTVSDBAccess e pela aplicação ERP que vão utilizar esta conexão.
A configuração do driver ODBC para Informix possui algumas abas de configurações (General, Connection, Environment, Advanced, e About ... ). Os pontos importantes destas configurações são:
Environment - Cursor Behavior Image Modified
O valor default para este parâmetro é "0-Close". Este parâmetro define o comportamento do banco com relação ao fechamento automático de cursores ( Queries ) quando efetuado um "commit work" ou "rollback work" em uma transação.
O Protheus e o TOTVSDBAccess esperam que não haja nenhum fechamento de cursor automático ao confirmar ou abortar uma transação. Deste modo, a configuração do "Cursor Behavior" deve ser igual a "1-Preserve", para o correto funcionamento do TOTVSDBAccess e das aplicações Protheus com o banco Informix.
Caso esta configuração não esteja adequada, podem ocorrer erros e mal-funcionamento de aplicações Protheus, como falhas em buscas de dados, cursores que terminam em EOF() antes de todas as linhas serem retornadas, e falhas na chamada e execução de Stored Procedure. Nestes casos, os seguintes erros são registrados no LOG do TOTVSDBAccess, em operações de Fetch:
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 ) |
Ambiente Linux - Configuração de ODBC.ini para TOTVSDbAccess |
O arquivo .ODBC.INI está localizado no diretório raiz do root (cd /root).
[ODBC] Trace=0 TraceFile=/tmp/odbctrace.out InstallDir=/usr/informix
[nomeconexao] Database= Servername=
CursorBehavior=1 |
Legenda |
Image Removed Image Removed | Descontinuado ou não homologado pelo fabricante e suportado pela TOTVS. |
Image Removed Image Removed | Descontinuado ou não homologado pelo fabricante e pela TOTVS. |
Image Removed Image Removed | Em processo de descontinuação pelo fabricante e suportado pela TOTVS. |
Image Removed Image Removed | Homologado pelo fabricante. |
Image Removed Image Removed | Homologado pelo fabricante e pela TOTVS. |
S.O. | Informix 7.31 | Informix 9.21 | Informix 9.30 | Informix 9.40 | Informix 10 | Informix 11.5 |
Windows 2000 Server | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Windows 2003 (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Windows 2003 (X86_64) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Windows 2008 (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Windows 2008 (X86_64) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Suse SLES8 (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Suse SLES8 (X86_64) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Suse SLES8 (Itanium) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Suse SLES9 (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Suse SLES9 (X86_64) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Suse SLES10 (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Suse SLES10 (X86_64) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
RedHat 2.1 AS / ES (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
RedHat 2.1 AS / ES (X86_64) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
RedHat 2.1 AS / ES (Itanium) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
RedHat 3 ES (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
RedHat 3 ES (X86_64) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
RedHat 3 ES (Itanium) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
RedHat 4.6 ES (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
RedHat 4.6 ES (X86_64) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
RedHat 5.1 ES (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
RedHat 5.1 ES (X86_64) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Solaris 6 | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Solaris 7 | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Solaris 8 | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Solaris 9 | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
Solaris 10 | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
IBM AIX 4.3.3 (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
IBM AIX 5.1.0 (X86) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
IBM AIX 5.1.0 (X86_64) | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
IBM AIX 5L 5.2 | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
IBM AIX 5L 5.3 | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed |
IBM AIX 6.1 | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed | Image Removed Image Removed