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