When connecting to a DB using JDBC-ODBC Bridge (sun.jdbc.odbc.JdbcOdbcDriver), how should the URL be formatted if a File DSN is to be used?
I'm using SquirreLSQL to connect with a File DSN stored on a network drive. It seems that JDBC-ODBC can't recognize the file. Or my URL could be wrong. It works when I use a system DSN. I've tried adding the network path to no avail.
I'm getting the below error for the URL jdbc:odbc:Z:\dir\dir\DATABASE.dsn
[Microsoft][ODBC Driver Manager] Connection not open