Fix ODBC and/or JDBC Connectivity in Excel for Mac 2016
Currently Excel for Mac 2016 fails to connect to our system using a JDBC connector provided by OpenLink. This could be brushed off, however Excel for Mac 2011 works perfectly on the same system.
The connection is made and data is correctly imported using 2011, but not 2016 on the same system. It fails with the following pop-up error via 2016:
[OpenLink][ODBC][JDBC Server]java.lang.NoClassDefFoundError: com/ibm/as400/access/AS400JDBCDriver
This would appear to be an OpenLink or Java error, however this is consistently reproducible on the same system with 2016 and works fine on the same system with 2011 via the same file.
James Brown commented
With version 15.25.1 ODBC almost works. I can get Microsoft Query to connect to the database, see the tables, execute the SQL query and receive that data.
But then when I click on 'Return Data' I get an error about how it can't load the driver.
This is slightly different to this bug, so I'll create a new one.