go to post Rupert Young · Sep 28, 2020 Hello Mark, Does the CSp.log show an authorization header with something like this? Authorization: NTLM TlRMTVNTU... When NTLM is in place the client sends the authorization header prior to the body post. However, the CSP gateway is not expecting this, hence the error. This may be resolved if you are on v2018+ as described here,https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GCRN_n... Otherwise, the way this has generally been resolved in the past is to modify the NTLM settings. One way this has been done is to change the NTLM authentication to "Authentication delegated - may authenticate directly”. Regards, Rupert
go to post Rupert Young · Feb 10, 2020 Have you checked: on the service machine that the service is listening on the port, netstat -na | grep 19757 on the operation machine that it can access the service machine, ping 10.136.4.142 on the operation machine that it can connect to the service, telnet 10.136.4.142 19757 Regards, Rupert
go to post Rupert Young · Jan 14, 2020 Hi Ken, I am assuming that you need the Caché ODBC drivers rather than SQL Server? How big is the query data? Could you share details/screenshot of the ODBC connection you have set up in SQL Server?