by Hi Michael,
We had the same problem with MSSQL Gateway.
Problem:
There are a problem with date format MULTINATIONAL4 (dd/mm/yyyy).
Solution:
Install the Gateway patch 6220.
I hope this help.
Leandro Fava
Ingres DBA
Setor de Informatica
Universidade de Santa Cruz do Sul - UNISC
> Enviada em: Thursday, May 25, 2000 8:55 PM
> Assunto: Ingres-Oracle Gateway Error
> We are getting the error message in Openroad 3.5/03
> E_GX008A Communications Error:
> An unsupported GCA message was received
> GCA_DATE_FORMAT[DB_MLT4_DFMT]
> when attempting to access an Oracle database table
> through the IngresII gateway to Oracle
> I can access the Oracle table through the terminal monitor
> with no problems so I am guessing that this may be a
> problem/feature/bug with Openroad 3.5/03.
> I would appreciate any help on this.
> TIA
> --
> Information Systems Barwon Water
> 61-67 Ryrie St Geelong Phone: +61 352 262326
> Victoria 3220 Australia Fax: +61 352 218236