Can you use the SQL inbound adapter to monitor the local Cache database?

Question

Question

James Woo · Dec 16, 2019

I configured a SQL inbound adapter to monitor my local Cache database.

But I got "ERROR <Ens>ErrOutConnectFailed: ODBC Connect failed for 'SAMPLES' /
'' with error ERROR #6022: Gateway failed: DSN/User Connect."

Same error if the DSN setting is blank or set to my namespace.

Question is whether SQL inbound adapter is for external database server ONLY?

Discussion (3)1

Log in or sign up to continue

Oliver Wilms · Dec 16, 2019

I am pretty sure I have used SQL Outbound Adapter with local cache database / namespace. I think you should be able to do the same for Inbound Adapter. I had to create a system DSN when I set this up on my Windows laptop.

0 0

score 0 · Answer 1 · 2019-12-16T16:53:14-05:00

Neerav Adam Verma · Dec 16, 2019

When you make a system dsn for intersystems cache type and press test connection. Does it succeed?

0 0

score 0 · Answer 2 · 2019-12-16T17:10:31-05:00

First, I have to use the ODBC Data Source Administrator to add and configure a System DSN for my namespace. Then I added the newly created DSN name to the SQL inbound adapter setting.