I tried this step as well but still the issue is present. Due to time constraints, we decided to use another approach for this project. Thank you for your assistance. 

Looks like it does, strangely. I double-checked everything. 

Thanks Jeffrey for the reply. Unfortunately, this did not work for me. As we are on older version it is cgate.so. There was a file called cgateur64.so. I copied cgate64.so to cgate.so. The connection test does not hang but no DSN name is listed in the following dropdown.

Hi Eduard,

Thanks for the tip. We could get this working by setting the DSN in the cacheodbc.ini file. But we have a problem establishing a connection. From SMP when we try to connect it times out. I tried the TestConnection method;

It keeps hanging. Any tips to troubleshoot this would be highly appreciated. 

Our version;

Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2017.2.2 (Build 865_3_20144U) Mon Aug 17 2020 13:28:18 EDT [HealthShare Modules:Core:15.032.9688 + Linkage Engine:15.032.9688]

Hassan

Thank you @David Reche  for the reply. I wish IRIS would release support for EF Core in the near future. For now we will develop our app based on IRIS and EF.