Re: [Rd] RJDBC

2007-03-07 Thread Jose Sierra
Thank you Simon. I have used your script with Oracle and Mysql and both returns [1] "Java-Object{java.sql.SQLException: No suitable driver}" My script is the next: library('rJava') library('DBI') library('RJDBC') drv <- JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-s

Re: [Rd] RJDBC

2007-03-05 Thread Simon Urbanek
Jose, On Mar 5, 2007, at 7:39 AM, Jose Sierra wrote: > 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:\\T

[Rd] RJDBC

2007-03-05 Thread Jose Sierra
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(dr

Re: [Rd] RJDBC

2007-03-05 Thread Jose Sierra
Thank you Sean. I send the message to R-help. Sean Davis escribió: > Jose Sierra wrote: >> 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') >> >> //Mysq

Re: [Rd] RJDBC

2007-03-05 Thread Sean Davis
Jose Sierra wrote: > 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.

[Rd] RJDBC

2007-03-05 Thread Jose Sierra
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