go to post Rupert Young · Oct 27, 2022 Hello Yone, Have a look here: https://docs.intersystems.com/healthconnectlatest/csp/docbook/DocBook.UI...
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?
go to post Rupert Young · Jan 7, 2020 Hi Ken, Would you just clarify from where and to where you are making the query? If you are querying Caché over a ODBC connection the Caché ODBC driver (CacheODBC35.dll) is installed as standard. If you are looking for the ODBC driver for the Microsoft SQL Server database you may be able to get it from here, https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15 Regards, Rupert
go to post Rupert Young · Nov 28, 2019 Perhaps you could expand on what you are trying to achieve. Where are you making the call from, odbc, objectscript, terminal? Which components are you working with? One option may be to embed the call to the stored procedure in objectscript code, SET a=7,b="A",c=99 &sql(CALL MyProc(:a,:b,:c)) https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_call Does that give you what you are looking for?