Written by

Question James Woo · Dec 16, 2019

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

#Caché #SQL

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

Add reply

Comments

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

Neerav Verma · Dec 16, 2019

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

0 0

James Woo Dec 16, 2019 to Neerav Verma

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.

0 0