[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