I am trying to connect to a Cache database. I can connect to to the database in question with a predefined ODBC DSN connection with my username and password.
What I want to do is use a SQL connector, Intersystems.Data.CacheClient.dll
to connect. I reference the DLL file, and pass my connection string containing the server IP, namespace and my login credentials, but the connection.open()
gives me Cache Security Error
.
I did grant permission in Cache to allow "ALL" permissions to my user.