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

Question

Question

Mohamed Hassan Anver · Dec 8, 2023

#Caché #Ensemble #HealthShare

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

Eduard Lebedyuk · Dec 8, 2023

DSN must be defined in <iris>/mgr/irisodbc.ini

0 0

score 0 · Answer 1 · 2023-12-09T07:44:49-05:00

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

score 0 · Answer 2 · 2023-12-10T08:37:05-05:00

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

score 0 · Answer 3 · 2023-12-10T09:28:21-05:00

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.

score 0 · Answer 4 · 2023-12-10T10:41:48-05:00

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.

score 0 · Answer 5 · 2023-12-10T11:09:42-05:00

Mohamed Hassan Anver · Dec 10, 2023

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

0 0

score 0 · Answer 6 · 2023-12-11T15:27:13-05:00

Eduard Lebedyuk · Dec 11, 2023

You need a restart following this rename. Also try to replace cgateu.so with cgateur64.so.

0 0

score 0 · Answer 7 · 2023-12-11T23:29:10-05:00

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.