Written by

Integration Engineer at Cognosante
Question Oliver Wilms · Nov 28, 2019

InterSystems Cache DSN

Hello,

I work with Ensemble Business Operation with SQL Outbound Adapter. I try to query a DSN defined database that happens to be Cache on the same machine in the same instance of Healthshare 2017.1.3. This worked fine on Linux server when I used JDBC driver. Now I want to run it on my Windows 10 laptop. I set up DSN and I can test connection successfully. I provided DSN in Operation DSN setting and I tried with and without Credential. I get ERROR <Ensd>ErrOutConnectFailed: ODBC Connect failed for 'myDSN'  / 'myDSN' with error ERROR #6022: Gateway failed: DSN/User Connect.

I tried to set up SQL Gateway Connection. I choose ODBC. I only see two DSN which were created by install for Samples and User databases. 

Any advice is welcome and will be appreciated.

Comments

Oliver Wilms · Nov 28, 2019

I believe I need System DSN, not User DSN. How do I create System DSN? I need to run Control Panel as Administartor? It does not allow me...

0
Oliver Wilms  Nov 28, 2019 to Robert Cemper

System DSN and Credential was required. Now it works without error. Thank you

0
Robert Cemper · Nov 28, 2019

You are on the right way.
It has to be a SYSTEM DSN.

in win10 clich to start
then click the GEAR symbol
next search for ODBC and you should be there.

OR

search from  WINDOWS control panel -> administration ->  ODBC data sources (64bit)  -> System DSN

0