Hi Scott,

I tried to test the connection to MS SQL Server 2005 with JDBC by a third-party SQL tool SQuirrel. Having the same connection string set up as the one in IRIS, using the same JDBC jar file, yet with a recent JDK (openjdk version "18.0.2" 2022-07-19), I was able to connect to the database of the target MS SQL Server instance.

Now I'm trying to figure out whether the JDK version made the differences. I didn't mention that in order to make it work, I had to modify the file java.security according to some posts (https://stackoverflow.com/questions/69623611/how-do-i-allow-java-client-...). But this was done before I switched JDK so that should be independent.

Thanks, Vitality. I got these error messages captured in the log file of the SQL Gateway Logging. It's good to see something new now.

Invalid Message Count (452); expected: -1 got: 1. Server returned: 19801. Closing Connection

My bad... and of that Youtube video. I had made those uuids in the bundle reckonlessly which caused the failure of resolving the references in IRIS. After I have corrected them into proper ones, that works!!