My ignorance! I managed to connect doing: library(RJDBC) cp <- c( "/opt/DbVisualizer-7.1.1/jdbc/mdb/log4j.jar", "/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_lang.jar", "/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_logging.jar" )
.jinit(classpath=cp) drv <- JDBC("jstels.jdbc.mdb.MDBDriver", "/opt/DbVisualizer-7.1.1/jdbc/mdb/mdbdriver.jar") con <- dbConnect(drv, "jdbc:jstels:mdb:/mnt/disco/data/fhi/roads/ROADSII.mdb") If there better ways please advice me. Thanks! Caveman On Sun, Jun 26, 2011 at 3:29 PM, Orvalho Augusto <orvaq...@gmail.com> wrote: > Corect me if this is not the right place to post this. > > I have a mdbdriver.jar (to access an MSAccess file) under Linux. I bought > the license from http://www.csv-jdbc.com/ guys. The driver work fine when > tested with DBVisualizer or another JDBC thing. > > The problem is that driver needs 3 other more jar files to work. Under R I > have tried this and does not work: > > library(RJDBC) > Loading required package: DBI > Loading required package: rJava > > .jaddClassPath("/opt/DbVisualizer-7.1.1/jdbc/mdb/log4j.jar") > > .jaddClassPath("/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_lang.jar") > > .jaddClassPath("/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_logging.jar") > > > > drv <- JDBC("jstels.jdbc.mdb.MDBDriver", > "/opt/DbVisualizer-7.1.1/jdbc/mdb/mdbdriver.jar") > Error in .jfindClass(as.character(driverClass)[1]) : > java.lang.NoClassDefFoundError: org/apache/log4j/PropertyConfigurator > > As you see I have added the log4j with .jaddClassPath. What is wrong? > > Caveman > > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.