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).
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.
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?
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?
I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I created
CREATE PROCEDURE Silk.sp_InsertRecord ( IN RecordDate TIMESTAMP, IN UserName VARCHAR(50), IN RecordType INT, IN RecordID VARCHAR(50), IN CategoryID INT, IN ApprovalDate TIMESTAMP, IN FileSize BIGINT, IN WorkstationName VARCHAR(50) ) BEGIN INSERT INTO DummyRecords ( RecordKey, FilePath, RecordDate, UserName,
All time