In order for InterFormNG to connect to a database, it needs a JDBC driver for the particular database type. The driver comes in the form of a .jar file which can usually be downloaded from the database vendor's website.
If the JDBC driver is missing, then you might get the error message:
Connection failed, error: No suitable driver is found for xxxx.
JDBC driver for AS400/iSeries/IBM i
On the AS400 platform you can find the jdbc driver as the jt400.jar file in the IFS in the path:
/QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar
JDBC driver for MS SQL server
The JDBC driver for MS SQL Server can e.g. be downloaded via this link:
This will download a zip file. After unzipping the file you can find the JDBC driver as the file: mssql-jdbc-11.2.0.jre8.jar
This works for InterFormNG2 version 3.4.3 and below.
For Version 3.5.0 and above, both the jre8 and jre11 jar version should work
You can then install it as described below.
Install the JDBC driver
You need to stop and start the InterFormNG2 service after installing a JDBC driver.
The installation is a matter of copying the JDBC driver to a folder.
For Version 3.5.0 and above of InterFormNG2:
In Windows the driver.jar should be placed in the folder:
<INTERFORMNG2-INSTALL-LOCATION>/libext
This is as default this path: C:\Program Files\InterFormNG2\libext
On the IBM i platform the driver should be placed in this folder:
/iformng2/InterFormNG-shell/Core/libext
For Version 3.4.3 and below of InterFormNG2:
On the Windows platform you should place the jdbc driver inside the subdirectories /jre/lib/ext of where InterFormNG2 is installed. That is default:
C:\Program Files\InterFormNG2\jre\lib\ext
On other platforms you should place the jdbc driver inside the directory of the JDK (Java Development Kit), that is used for InterFormNG2.
On the IBM i platform it can e.g. be: /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit/jre/lib/ext
