Being relatively new to R, I want to use R in connection with a MySQL database. After installing (apparently sucessfully) the package RMySQL (R Version 1.6.2) the result is as follows:> library(RMySQL) > con <- dbConnect(MySQL(), dbname= "test")Error: couldn''t find function "dbConnect" Thank You in advance for help Peter Jörg Peter Baresel Technische Universität München Lehrstuhl für Pflanzenbau und Pflanzenzüchtung D-85354 Freising Lange Point 51 [[alternate HTML version deleted]]
It needs package DBI: do you have that installed too? See the dependency list for RMySQL in its DESCRIPTION file. On Fri, 7 Feb 2003, J?rg Peter Baresel wrote:> Being relatively new to R, I want to use R in connection with a MySQL database. > After installing (apparently sucessfully) the package RMySQL (R Version 1.6.2) > the result is as follows: > > > library(RMySQL) > > con <- dbConnect(MySQL(), dbname= "test") > Error: couldn't find function "dbConnect"-- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
I don't know if this is the proper forum but here goes: I'm trying to install the RMySQL library under Windows XP. The instructions say to use reimp to create an R-compatible MySQL library file "libmysql.dll" but when I try to run reimp I get the error "reimp: dlltool: No such file or directory" Obviously something is missing or can't be found but I can't tell what from the message! I'm using fresh downloads of mingw utils and the RMySQL library. And of course the library doesn't work in R - I get the message "Error in testRversion(descfile) : This package has not been installed properly See the Note in ?library" when I try to load it. Other libraries work fine. I realize this failure is due to the reimport failure. Any suggestions? Bob Meeks
Thank you - it works great now.>From: ripley at stats.ox.ac.uk >To: r meeks <rmeeksweb at hotmail.com> >CC: r-help at stat.math.ethz.ch >Subject: Re: [R] RMySQL >Date: Sat, 15 Feb 2003 17:14:50 +0000 (GMT) > >dlltool is part of the compiler set, so that's where your troubles begin. > >However, the instructions are not those for the binary install. All you >need to do is to get RMySQL.zip from CRAN and put RMySQL/libs/libmysql.dll >somewhere in your path. > >On Sat, 15 Feb 2003, r meeks wrote: > > > I don't know if this is the proper forum but here goes: > > > > I'm trying to install the RMySQL library under Windows XP. The >instructions > > say to use reimp to create an R-compatible MySQL library file >"libmysql.dll" > > but when I try to run reimp I get the error "reimp: dlltool: No such >file or > > directory" > > > > Obviously something is missing or can't be found but I can't tell what >from > > the message! I'm using fresh downloads of mingw utils and the RMySQL > > library. > > > > And of course the library doesn't work in R - I get the message "Error >in > > testRversion(descfile) : This package has not been installed properly > > See the Note in ?library" when I try to load it. > > > > Other libraries work fine. I realize this failure is due to the >reimport > > failure. > > > > Any suggestions? > >-- >Brian D. Ripley, ripley at stats.ox.ac.uk >Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ >University of Oxford, Tel: +44 1865 272861 (self) >1 South Parks Road, +44 1865 272866 (PA) >Oxford OX1 3TG, UK Fax: +44 1865 272595 > >______________________________________________ >R-help at stat.math.ethz.ch mailing list >http://www.stat.math.ethz.ch/mailman/listinfo/r-help