From jose.sierra at integromics.com  Mon Mar  5 14:02:33 2007
From: jose.sierra at integromics.com (Jose Sierra)
Date: Mon, 05 Mar 2007 14:02:33 +0100
Subject: [Rd] RJDBC
In-Reply-To: <45EC1231.20108@mail.nih.gov>
References: <45EC0F6A.20309@integromics.com> <45EC1231.20108@mail.nih.gov>
Message-ID: <45EC14E9.7090401@integromics.com>

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')
>>
>> //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?
>>   
> Jose,
>
> This message should go to the R-help or the R-SIG-DB list.  When you 
> send it, I suggest you include your Java version, the output of a call 
> to sessionInfo(), and let folks know whether you can connect from your 
> machine using JDBC in Java.  I don't use RJDBC, so I can't help 
> directly--sorry.
>
> Sean
>

		
______________________________________________ 
LLama Gratis a cualquier PC del Mundo. 
Llamadas a fijos y m?viles desde 1 c?ntimo por minuto. 
http://es.voice.yahoo.com



[Rd] RJDBC
Jose Sierra