Hello,
I am trying to "select" rows from a MS access table using:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ="+ filenamek + ";READONLY=true}";
It works prefectly on my local machine (XP) but when the project is deployed (web application) in a unix box and I am getting this error:
java.lang.NullPointerException at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at TEST.ACCESS_dbConnection.ACCESS_connect(ACCESS_dbConnection.java:38)
at _accessgetdata._jspService(_accessgetdata.java:79)[SRC:/accessgetdata.jsp:34]
.....
.....
is it possible to connect into a MS table through a web application?
The user is going to select a MS access DB from his/her computer and the system is going to read all the rows to insert them into a oracle table.
0
dbc
river={Microsoft Access Driver (*.mdb)};DBQ="+ filenamek + ";READONLY=true}";
