QIE is a Java based application. As such let's shift a bit to talk about Java, JDBC and ODBC.
Java, JDBC, and ODBC
The short answer is "yes" Java can connect to ODBC data sources but, it is not recommended. Although, Java does not support ODBC directly. There is a JDBC/ODBC bridge driver that can be used to connect to ODBC data sources. This made sense in the early days of Java but now there is an abundance of JDBC drivers.
NOTE: Up to JAVA version 7, Java included its own JDBC/ODBC bridge driver. Starting with Java 8 it is no longer included in the JDK.
QIE and using JDBC to connect to a database
So, with that out of the way how do you install a JDBC driver in QIE?
1. Place driver in QIE lib folder. Below we have included the Oracle and MySQL drivers. Note the Microsoft SQL driver ships with QIE so step 1 and 2 may be skipped.
2. In QIE select the driver. System Administration -> System Administration -> Manage External Libraries
3. Restart QIE.
4. Create and test JDBC connection. Note: The image below is connecting to Microsoft SQL Server.
See also:
References:
