[R] RMySQL...Can't initialize driver???
Rainer M Krug
rkrug at sun.ac.za
Wed Jun 28 09:29:45 CEST 2006
Stephane Cruveiller wrote:
> Rainer M Krug wrote:
> I followed your instruction. Here is my .my.cnf:
> ---------------------------------------------------------------------------
> [client]
> user=steff
> password=XXXXXX
> database=justforfun
> ---------------------------------------------------------------------------
> with it, I can connect to my MYSQL server without problem
> and then I try to connect through R:
>
> ---------------------------------------------------------------------------
>> library(RMySQL)
> Loading required package: DBI
>> m <- dbDriver("MySQL")
> Error in new("MySQLDriver", Id = drvId) : unused argument(s) (Id ...)
> ---------------------------------------------------------------------------
>
> It still produces the error. I really do not know what is going on
> here...
Sorry - no idea. I guess you are using Linux? And all packages are up to
date?
Rainer
>
>
>> Then you do:
>>
>>
>> library("RMySQL")
>> m <- dbDriver("MySQL")
>> con <- dbConnect(m, group = "renpatch")
>> q <- TheSQLQuery
>> rs <- dbSendQuery(con, q)
>> TheResults <- fetch(rs, n = -1)
>> dbDisconnect(con)
>> rm(con)
>>
>>
>> and it should work - at least that is what it is doing for me.
>>
>> Rainer
>>
>>
>
> Stephane.
--
Rainer M. Krug, Dipl. Phys. (Germany), MSc Conservation
Biology (UCT)
Department of Conservation Ecology and Entomology
University of Stellenbosch
Matieland 7602
South Africa
Tel: +27 - (0)72 808 2975 (w)
Fax: +27 - (0)21 808 3304
Cell: +27 - (0)83 9479 042
email: RKrug at sun.ac.za
Rainer at krugs.de
More information about the R-help
mailing list