On 6/27/2006 8:51 AM, 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?
I have never used RMySQL, but from the error message, this looks like an
incompatibility between it and DBI, presumably because one is newer than
the other.
I have always found it easier to use RODBC. Because it uses the more
general ODBC interface, it may be slower than a package that is tuned to
a particular database, but it works, which is a substantial advantage.
Duncan Murdoch
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
