Try using SQL Gateway:

https://docs.intersystems.com/iris20221/csp/docbook/DocBook.UI.Page.cls?...

Most likely server you are connecting to requires tls 1.1 or tls 1.2. Ensemble 2014.1 is quite old. Consider upgrading.

You can try to find out what protocol server supports via nmap (https://nmap.org/nsedoc/scripts/ssl-enum-ciphers.html)

Check sc using zwrite sc -- you'll see the Save errors.

Also, see the "Creating the Server Configuration Items Programmatically"

I would even advise to use UNION ALL, because with UNION IRIS checks if resulting set has no duplicate rows, and there is no need to do this check with INSERT.

@Dmitry Maslennikov has nice series of articles on how globals are stored.

First one -- Internal Structure of Caché Database Blocks, Part 1

I'm glad that helped! This is why we all here -- to learn something new! :-)

Or

do $system.DeepSee.Shell()

I got 485 on 24 lines.

Mario, where is the link to the utility?

SQL Gateway uses %JDBC.Server to connect to 3rd party databases via JDBC.

SQL Gateway connection is the database connection settings.
%JDBC.Server settings are the settings for the java process that handles these connections.

"The driver cannot be loaded" most likely means that you specified wrong path to the jar file with the MSSQL driver. Or IRIS process does not have permission to access this jar file.

Try also running two following commands from the terminal. They might give some hint on what's wrong

do $system.SQLGateway.TestConnection("ConnectionName")
zwrite %objlasterror

USER>d ^quine
 set q = $C(34) kill a //stolen from Wikipedia Java example
 set a($I(a)) = " set q = $C(34) kill a //stolen from Wikipedia Java example"
 set a($I(a)) = " set a($I(a)) = "
 set a($I(a)) = " write a(1),! "
 set a($I(a)) = " for i=1:1:a { "
 set a($I(a)) = "    write a(2),q,a(i),q,! "
 set a($I(a)) = " }"
 set a($I(a)) = " for i=3:1:a {"
 set a($I(a)) = "    write a(i),!"
 set a($I(a)) = " }"
 write a(1),! 
 for i=1:1:a { 
    write a(2),q,a(i),q,! 
 }
 for i=3:1:a {
    write a(i),!
 }