Hey all, I tried the instructions listed here:
Dynamic DSN instructions
They're not working for me for some reason.
It works if I getConnection(url), using the system DSN "notes", but if I try to do it on getConnection(DB_URL_PREFIX), I get this:
java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at #my package redacted#.model.DAO.getConnection(DAO.java:21)
at #my package redacted#.model.DocumentGateway.getNextDocumentId(DocumentGateway.java:14)
at #my package redacted#.model.DocumentManager.getNextDocumentId(DocumentManager.java:19)
at #my package redacted#.CompAnnotate.<init>(CompAnnotate.java:150)
at #my package redacted#e.CompAnnotate.main(CompAnnotate.java:59)
I've tried every possible variant of the path separator, including, \, \\, /, and File.pathSeparator. I've tried it with and without the ";DriverID=22;READONLY=false";" suffix. Always the same error.
Any ideas?
/willy