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