Connection problem with %SQLGatewayConnection

Question

Question

I'm trying to make a connection to an external database using %SQLGatewayConnection, but the connection always fails. DSN properly configured. I try to make the same connection through isql in bash, and the connection is successful.

This same connection fails in Caché.

Product version: Caché 2018.1

Discussion (4)1

Log in or sign up to continue

score 0 · Answer 1 · 2024-10-04T15:47:55-04:00

David Hockenbroch · Oct 4

What error text are you seeing when you try that?

0 0

score 0 · Answer 2 · 2024-10-04T17:20:19-04:00

Matheus Augusto · Oct 4

ERROR #6022: Gateway failed: DSN/User Connect.

0 0

score 0 · Answer 3 · 2024-10-07T08:05:59-04:00

David Hockenbroch · Oct 7

If you test the connection in your System Management Portal, does it fail there too?

0 0

score 0 · Answer 4 · 2024-10-07T08:17:53-04:00

Matheus Augusto · Oct 7

Returns successful connection even with incorrect data.

0 0