• Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem connecting MS Access using jdbc:odbc  RSS feed

slav agui
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:
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.

Thanks a lot for ANY help!!!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!