Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems.
I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I created
CREATE PROCEDURE Silk.
I have set up an ODBC driver for InterSystems and would like to set up a linked server. This all works except I cannot see the columns details. If I access the database from excel I can get the columns and types of the various tables
Any help or instructions would be appreciated
Terry
Any plans for ODBC 3.8 support?
Hi Team,
We are facing an issue connecting to a remote Cache DB server using CacheODBC 2018 on the client side.
The connection works fine without SSL on the Cache server, but when SSL is enabled, we are getting the below error - "Failed to load cconnect executable!, SQL state 08S01 in SQLConnect"
Also, the connection works fine when the PHP script is run through CLI on client server, but fails with the above error when the script invoked from a client browser.
Could you please help us with any pointers in resolving the issue?
Hi,
Does anyone have experience with connecting to IRIS with OLEDB through an OLEDB-ODBC bridge? In this case the client can only speak OLEDB at this moment.
Regards,
Marcel
I tried both the latest 32-bit and 64-bit Cache ODBC drivers, but I’m getting this “Message sequencing error” when I attempt to connect to the Cache server. Client is a Windows Server 2022. Server is a 2008 version of Cache ( or customer thinks). I’ve tried a number of things without success. If I enter invalid credentials I do get the quick “Access Denied” response. But when I have the proper IP/port/namespace/credentials I consistently get this error below. Google shows others struggle with that error, but no resolution.
Is it possible to authenticate an xDBC (ODBC/JDBC) connection to InterSystems IRIS via (a 3rd party) OAuth server?
For REST APIs this is possible, but could this be achieved with OAuth?
Out-of-the-box the ODBC/JDBC Drivers don't seem to have this option, but maybe some custom code could enable this? perhaps via Delegated Authentication and some OAuth classes customization, or some other way?
Has anyone done this already and can share how it was implemented, or someone with some guideline suggestions?