Not able to connect IRIS DB via DBeaver

Question

Denny Zhu · May 30, 2021

when i connect to DB via DBeaver , it always report Connection refused, i tried both Cache and IRIS but same error, I have already download intersystems-jdbc-3.2.0.jar as IRIS Driver.

And meanwhile SqlDBx tool is able to connect via internal Intersystems Cache Driver.

Product version: IRIS 2019.1

$ZV: 2019.1 (Build 510_4_20145U)

Discussion (2)1

Nicky Zhu · May 31, 2021

Hi Denny,

I think the most common cause of a refused connection is OS firewall blocking the superserver port of IRIS, which is used by JDBC connections. You can try close the firewall or open the superserver port in firewall settings.

I remember that SqlDBx is using ODBC to connect to DBs, so it will use a different connection.

0 0

Dmitry Maslennikov · May 31, 2021

Could you share your connection settings? It should use super port 1972

1 0