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 <orvaquim@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]]

