I'm tying to make a DSN-less connection to a file and I tried multiple methods which seem to work for other people but everytime I try I get:
class java.sql.SQLException error: [Microsoft][ODBC Driver Manager] Data source
name too long
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name too lon
g
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:4089)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:1136)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:1
48)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:167)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:159)
at ExcelTest.doSomething(ExcelTest.java:14)
at ExcelTest.main(ExcelTest.java:25)
press any key to exit...
please help!