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

[Duncan Murdoch]

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