From jmanuel_sierra at yahoo.es  Mon Mar  5 13:06:02 2007
From: jmanuel_sierra at yahoo.es (Jose Sierra)
Date: Mon, 05 Mar 2007 13:06:02 +0100
Subject: [Rd] RJDBC
Message-ID: <45EC07AA.4030109@yahoo.es>

I need help.

I'm trying to connect with an Oracle DBMS and MySQL DBMS, I'm using 
RJDBC package.

My code is the next:

library('rJava')
library('DBI')
library('RJDBC')

//Mysql
drv <- 
JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'")
conn <- dbConnect(drv, "jdbc:mysql://localhost:3306/bd", "user", "password")

//Oracle
drv <- 
JDBC("oracle.jdbc.driver.OracleDriver","C:\\Temporal\\classes12.jar","'")
conn <- dbConnect(drv,"jdbc:oracle:thin:@192.168.1.70:1521:SDS22","user","password")

R always returns for oracle
 "Error en .local(drv, ...) : Unable to connect JDBC to jdbc:oracle:thin:@192.168.1.70:1521:SDS22"
and for mysql
 "Error en .local(drv, ...) : Unable to connect JDBC to jdbc:mysql://localhost:3306/bd"

And the function summary(drv) returns:
JDBCDriver
name = JDBC
driver.version = 0.1-1
DBI.version = 0.1-1
client.version = NA
max.connections = NA

Can you help me, please?

Another question: 

I try to compile ROracle and RMysql for windows but i need Rdll.lib and it need R.exp. Can you give me one of this files?

 
Regards.
Jose Sierra



[Rd] RJDBC
Jose Sierra