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

From: Rainer M Krug <rkrug_at_sun.ac.za>
Date: Wed 28 Jun 2006 - 17:29:45 EST

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@sun.ac.za
      	Rainer@krugs.de

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Received on Wed Jun 28 17:32:43 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Wed 28 Jun 2006 - 18:12:37 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.