JDBCODBC « ODBC « Java Database Q&A

1. Querying Excel 2007 Workbook with JDBC/ODBC    stackoverflow.com

I've created an ODBC connection to an Excel 2007 Workbook using ACEODBC.dll, which is supposed to work for both .xls and .xlsx files. However when I try to open a connection ...

2. java.sql.SQLException: General error at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)    stackoverflow.com

I'm trying to establish a JDBC-ODBC connection using the following routine,

private static Connection getConnection(String systemDSN, String username, String password) throws Exception {
    String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
   ...