[R] RMySQL...Can't initialize driver???

[David James]

Stephane CRUVEILLER wrote:
> Dear R users,
> 
> I would like to query a MySQL database through R. I have installed
> the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL
> server (v5.0.22) is running on my local machine but I can't initialize MYSQL 
> driver: 
> ------------------------------------------------------------------------------------
> > library("RMySQL")
> Loading required package: DBI
> > MySQL(max.con = 10, fetch.default.rec = 500, force.reload = F)
> Error in new("MySQLDriver", Id = drvId) : unused argument(s) (Id ...)
> -------------------------------------------------------------------------------------
> 
> Could somebody tell me what I have missed?

Hmm, I can't reproduce the problem:

   > m2 <- MySQL(max.con = 16, fetch.default.rec = 500, force.reload = F)
   > summary(m2, verbose=TRUE)
   <MySQLDriver:(31672)>
     Driver name:  MySQL
     Max  connections: 16
     Conn. processed: 0
     Default records per fetch: 500
     DBI API version:  0.1-10
     MySQL client version:  4.1.7
     Open connections: 0

   > version
                  _
   platform       i686-pc-linux-gnu
   arch           i686
   os             linux-gnu
   system         i686, linux-gnu
   status
   major          2
   minor          3.1
   year           2006
   month          06
   day            01
   svn rev        38247
   language       R
   version.string Version 2.3.1 (2006-06-01)

--
David

> 
> 
> Thx
> 
> St?phane.
> 
> 
> -- 
> ==========================================================
> Stephane CRUVEILLER Ph. D.
> Genoscope - Centre National de Sequencage
> Atelier de Genomique Comparative
> 2, Rue Gaston Cremieux   CP 5706
> 91057 Evry Cedex - France
> Phone: +33 (0)1 60 87 84 58
> Fax: +33 (0)1 60 87 25 14
> EMails: scruveil at genoscope.cns.fr ,scruvell at infobiogen.fr
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html