· Dec 8, 2023

SQL Server ODBC connection with DSN created, does not display in list of DSNs in SQL Gateway connection screen.

DSN created and tested in Linux;

This DSN does not list SQLGateway connection->DSN list


I have set the LibPath

Discussion (8)2
Log in or sign up to continue

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]


I experienced a similar issue when configuring the MSSQL ODBC driver for IRIS. It appears as though the default is 32 bit, and I was able to get it working through the following steps:

  1. Change the working directory to Caché's /<install-dir>/bin
  2. Copy to
  3. Copy to