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;
.png)
This DSN does not list SQLGateway connection->DSN list
.png)
I have set the LibPath
Comments
DSN must be defined in <iris>/mgr/irisodbc.ini
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
I experienced a similar issue when configuring the MSSQL ODBC driver for IRIS. It appears as though the default odbcgateway.so is 32 bit, and I was able to get it working through the following steps:
- Change the working directory to Caché's /<install-dir>/bin
- Copy odbcgateway.so to odbcgateway32.so
- Copy odbcgatewayur64.so to odbcgateway.so
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.
Double check the <install-dir>/mgr/cacheodbc.ini file. I don't think changing the shared object file should have any effect on the visibility of the DSN in the Management Console, but I could be wrong.
Looks like it does, strangely. I double-checked everything.
You need a restart following this rename. Also try to replace cgateu.so with cgateur64.so.
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.