[R] DBI / MySQL problems

[David James]

Luis Torgo wrote:
> Hi.
> I frequently use RMySQL package to interface R with MySQL databases. I was 
> having a try with package DBI and I got the following error:
> 

The version of RMySQL that you have is not DBI-compliant.  The new version
RMySQL 0.5-0 is.   With the very-soon release of R 1.6.0 there will be
DBI-compliant packages for Oracle, MySQL, and SQLite (they all will require
1.6.0).

I'd suggest to wait a couple of weeks, upgrade to 1.6.0 and try DBI/RMySQL again.

Regards,

--
David

> > library(RMySQL)
> > library(DBI)
> > drv <- dbDriver("MySQL")
> > ch <- dbConnect(drv, dbname="mydb", user="myuser", password="mypasswd")
> > ibm <- dbGetQuery(ch,"select * from table where field1='val'")
> Error in dbGetQuery(ch, "select * from table where field1='val'") : 
> 	No direct or inherited method for function "dbGetQuery" for this call
> 
> 
> Even other things like for instance:
> 
> > dbListTables(ch)
> Error in dbListTables(ch) : No direct or inherited method for function 
> "dbListTables" for this call
> 
> Produce the same kind of error...
> 
> I've already browsed through the documentation accompnying DBI but I have no 
> clue on what am I doing wrong....
> 
> > R.version
>          _                
> platform i686-pc-linux-gnu
> arch     i686             
> os       linux-gnu        
> system   i686, linux-gnu  
> status                    
> major    1                
> minor    5.1              
> year     2002             
> month    06               
> day      17               
> language R    
> 
> Thanks for any help,
> luis
> 
> -- 
> Luis Torgo
>     FEP/LIACC, University of Porto   Phone : (+351) 22 607 88 30
>     Machine Learning Group           Fax   : (+351) 22 600 36 54
>     R. Campo Alegre, 823             email : ltorgo at liacc.up.pt
>     4150 PORTO   -  PORTUGAL         WWW   : http://www.liacc.up.pt/~ltorgo
> 
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

-- 
David A. James
Statistics Research, Room 2C-253            Phone:  (908) 582-3082       
Bell Labs, Lucent Technologies              Fax:    (908) 582-3340
Murray Hill, NJ 09794-0636
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._