Does QIE support ODBC?

0 votes
asked Apr 14, 2016 by rich-c-2789 (15,250 points)
I need to connect to MS SQL Server.  How can I create a connection in QIE?

1 Answer

0 votes
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.
The preferred way to connect to a data source with Java is with a JDBC driver.  For more detail please see the JDBC Overview:
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:
Questions with the database or JDBC tags
answered Apr 14, 2016 by rich-c-2789 (15,250 points)