User comments | InterSystems Developer Community

Rupert Young · Jan 14, 2020 go to post

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?

Rupert Young · Nov 28, 2019 go to post

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?

Rupert Young · Jan 7, 2020 go to post

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

Rupert Young · Feb 10, 2020 go to post

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

Rupert Young · Sep 28, 2020 go to post

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_…

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

Rupert Young · Oct 27, 2022 go to post

Hello Yone,

Have a look here:

https://docs.intersystems.com/healthconnectlatest/csp/docbook/DocBook.U…

User statistics