[R] DBI / MySQL problems

[Luis Torgo]

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:

> 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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._