[R] RMySQL...Can't initialize driver???
Stephane Cruveiller
scruveil at genoscope.cns.fr
Tue Jun 27 15:09:51 CEST 2006
Duncan Murdoch wrote:
> 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.
thanks for the hint... I will give it a try very soon.
>
> Duncan Murdoch
>
Stephane.
More information about the R-help
mailing list