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

[Stephane Cruveiller]

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.