Thanks you for reply Cesar,
In short, all components are on the same host as shown below.
I will try again with a lower version of SQL SERVER.
Informix 14.10.FC4W1DE (dbaccess) ===> EGM 7.31.UD4 / DataDirect ODBC ===> SQLSERVER 2017
sqlhosts (Informix 14.10)ol_informix1410_2 onsoctcp db2 ol_informix1410_2
dr_informix1410_2 drsoctcp db2 dr_informix1410_2
lo_informix1410_2 onsoctcp 127.0.0.1 lo_informix1410_2
egm731ud4 onsoctcp db2 9660sqlhosts (EGM)egm731ud4 onsoctcp db2 9660In addition, thank you for sharing your issues.
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
Original Message:
Sent: Fri September 11, 2020 07:36 AM
From: Cesar Martins
Subject: Informix Enterprise Gateway Manager Error
Hi SangGyu ,
My guess is you have different sqlhosts configuration there.
On the sqlhosts of your database you don't set the egm731ud4 host.
Using the direct mode, the dbaccess will use the local SQLHOSTS.
BTW, here I'm using EGM 7.31.ud4x1 to connect SQLSERVER versions 2000, 2008, 2008 R2, 2014, and all works fine.
The unique issue I have with it is a huge flaw on the Datadirect ODBC when you interrupt a statement, they don't interrupt on the SQLSERVER, your EGM will receive 100% of the data. So if you have a SELECT which returns 1 million records and you fetch only the first record and close the cursor, your session will freeze waiting for the EGM receiving the rest of the 999.999 records to free your cursor... so, beware.
We use with EGM accessing Oracle databases and this issue doesn't happen.
Regards
Cesar
Original Message:
Sent: 9/10/2020 8:30:00 PM
From: SangGyu Jeong
Subject: Informix Enterprise Gateway Manager Error
Hi All,
I am testing connecting to the mssql server through egm.
When connecting to the mssql data source using dbaccess directly as shown below, sql runs fine.
Instead, when using in the form of distributed query as shown below, a 908 error occurs and the egmd process crashes.
Is there any way to see if this is happening for some reason?
The EGM is version 7.31.UD4, and the environment variable GWDIRECTMODE is set to 1.
I also tried setting GWDEBUG=121,122,123 but there was no debug message when the egmd process was down.
Thanks for reading.
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
#Informix