Database driver

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:

https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16

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 the IBM i platform it can e.g. be:

 /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit/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.