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

From: David James <dj_at_research.bell-labs.com>
Date: Wed 28 Jun 2006 - 00:11:43 EST

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@genoscope.cns.fr ,scruvell@infobiogen.fr
>
> ______________________________________________
> R-help@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
______________________________________________ R-help@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
Received on Wed Jun 28 01:27:57 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Wed 28 Jun 2006 - 02:12:47 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.