While %FromJSON() accepts a String or a character Stream as Input
you have in IRIS also %FromJSONFile() that allows direct input from file
and shortcuts the creation of a Stream.
But for both cases take care of encoding  (I'm burned)
​​​​​​​NOTE: RFC 7159 specifies that the default encoding for JSON values uses UTF-8

??

SQL type TEXT maps correctly to %Stream.GlobalCharacter,
- anyhow this gets not granted on the way from ADO to IRIS-

it would be useful to check if the behavior is the same with a normal ODBC tool.
I tested recently the opposite direction from IRIS to WinSQL and that was OK.

Since transmitting streams always requires some chopping and assembling
at both ends not to break the buffers, it is important if the error persists outside ADO.

just a minor part:
Is it possible while sending an insert/Update to database via the ado driver for iris, that this SQL is executed without creating a cached query?
NO:
In IRIS and also the latest of Caché / Ensemble every query is cached. 
real non-cached queries date back by ~ 10 years. It wasn't just that visible.
 
As you describe it, it seems the LONGVARCHAR or LONGVARBINARY
are not honored correctly when coming from ADO.

pls. Check the related class definition.
And be aware that once created as VARCHAR it can't be changed  
dynamically to LONGVARCHAR  on the fly. This type is a static definition.

check Global ^ROUTINE(<your routine>)

I see you disliked my previous reply and retitled your article.
so again:

Could be, I misunderstand the purpose of the example.
Before LOAD DATA was available with IRIS this was the still valid approach

• I opened my CSV in EXCEL
• Connected by the EXCEL DSN over SQL Gateway using ODBC
• and did the import.
• %XML.Adaptor does the rest. If required at all.

And was done before my breakfast coffee became even lukewarm.
And not a single line of code was required!

Sorry, where is the advantage?

And personally, I prefer to work with well trained qualified engineers
instead of a guess & try a program somewhere whether for Py or COS or anything else.
 

What about this ?
 

USER>set r="" for i=1:1:7 set r=$O(^$ROUTINE(r)) quit:r=""  write r,!
%APILIB
%APILOG
%APISERV
%ASKDIR
%ASKSYS
%AUDIT
%Activate.Enum.0
 
USER>

https://docs.intersystems.com/iris20223/csp/docbook/Doc.View.cls?KEY=RCOS_sroutine

I would like to see this as an important and useful Tutorial!

And definitely more useful than copying the use of Class queries 3 times at least.
 

At your own risk!
You can set the Code DB of your namespace to R/W.

Does it work if you call your class with full reference? I mean not for Login?
NOT found is suspicious somehow

Sorry, HL7 is not my world.  

or use IRIS Native API for ObjectScript

Another idea:
Just to see that the port is open and you are on IRIS  you may try to access
over ODBC/JDBC gateway any table in %SYS

if you insist on that line you need

Set Jsonobj="{""Doctype"":""ADT^A01"",""PatientId"":""123"",""PatientName"":""Alex""}"

ODBC/JDBC QUERY tools connect to 1972
no Idea which runs on Linux