Connection problem with %SQLGatewayConnection
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.
.png)
This same connection fails in Caché.
.png)
Comments
What error text are you seeing when you try that?
ERROR #6022: Gateway failed: DSN/User Connect.
If you test the connection in your System Management Portal, does it fail there too?
Returns successful connection even with incorrect data.
The solution was to connect using the portal's "SQL Gateway Connections" with JDBC (Figure 1). After configuring this connection, it was possible to link the table within CACHÉ in the SQL area using "Wizards -> Link Table" (Figure 2). The table to be linked must have a sequence.
Figure 1..png)
Figure 2.png)