Request for new database: SAP IQ

[ASk1]

SAP IQ (ex Sybase IQ)

[ASk1]

SAP ASE (Sybase) not connects:
java.sql.SQLException: Invalid state, the Connection object is closed. at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481) at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767) at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722) at net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:966) at crates\java-rs\src\java\java_env_wrapper.rs:851 at crates\java-rs\src\java\java_env_wrapper.rs:323

[mikeburgh]

Yes ASE is different to anywhere/IQ from what I am reading..

There are two paths to enable anywhere/iq support.. one is windows only, and uses the .dll if you already have the anywhere/iq client tools installed.

Other is to go java and requires you to provide the path to the jconn4.jar file.

I am leaning toward the java path as it will work across the various os platforms.. are you familiar with downloading/providing that jar ? from a quick check in my old DB tool that was the same pattern they used for connecting to these SAP engines.

[ASk1]

I have iq client installed both in windows with dlls and in wsl.
There are both sajdbc4.jar, which is preffered way to connect sap iq, and jConnect-16_0 with jconn4.jar, jconn42.jar, jTDS3.jar, jTDS4.jar