Connecting with ODBC Connection on the Server

Reported for version 8


DQC cannot run a plan with ODBC driver connection and throws error:  Failed to instantiate database driver 'sun.jdbc.odbc.JdbcOdbcDriver' on Linux OS.


The JdbcOdbcDriver is not included in the OpenJDK package and Oracle Java version 8 package. There are two ways to use ODBC Driver with DQC:

  1. Install Oracle Java 6 or 7.
  2. Find an appropriate JDBC-ODBC bridge driver from a third-party manufacturer.