I have been able to connect to our SQL server and retrieve the tables I need through a direct connection. However, when I try the same for the Intersystems Cache database I run into an error.

The system administrator can see that I pass through the firewall, so that's not the issue. I have the feeling that is has to do with the obligatory Cache namespace, when I setup a ODBC connection myself it only works when this field is properly given.

I expected it to work when I configured it like this but it provides the error message showed earlier within a second.

Anyone any ideas on how this could work?