What do I need to do to load the RMySQL library on Win 2K using version 1.8.1 I have Mysql v4.0.16 up and running on the local machine with several databases running fine. Using RGUI I have loaded RMySQL and an appropriate directory structure has appeared under C:\Program Files\R\rw1081\library\RMySQL I have added C:\Program Files\R\rw1081\library\RMySQL\inst\libs to my path variable so that libmySQL.dll can be found. If I type library(), then I see RMySQL in the list of available packages. If I try and load the library, I get > library(RMySQL) Error in testRversion(descfields) : This package has not been installed properly See the Note in ?library Where am I going wrong? Thanks, Ian.
Where did you get RMySQL from and how did you `load' it? Most likely you unpacked a source distribution instead of installing. There is a binary version of RMySQL available at http://stat.bell-labs.com/RS-DBI/download If you didn't use that, please try it. On Sun, 14 Mar 2004, Ian Long wrote:> What do I need to do to load the RMySQL library on Win 2K using version 1.8.1 > > I have Mysql v4.0.16 up and running on the local machine with several > databases running fine. > > Using RGUI I have loaded RMySQL and an appropriate directory structure has > appeared under > C:\Program Files\R\rw1081\library\RMySQL > > I have added C:\Program Files\R\rw1081\library\RMySQL\inst\libs to my path > variable so that libmySQL.dll can be found. > > If I type library(), then I see RMySQL in the list of available packages. > > If I try and load the library, I get > > library(RMySQL) > Error in testRversion(descfields) : This package has not been installed > properly > See the Note in ?library > > Where am I going wrong? > > Thanks, > Ian. > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html > >-- 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
That works perfectly, thank you. The question of how did I "load it" is a hard one to answer - over the past two weeks I have had a variety of different attempts. I believe as you suggest, I had a source distribution and was struggling to find out how to compile it. Many thanks for your efforts, Ian. At 22:08 14/03/2004 +0000, Prof Brian Ripley wrote:>Where did you get RMySQL from and how did you `load' it? > >Most likely you unpacked a source distribution instead of installing. >There is a binary version of RMySQL available at > >http://stat.bell-labs.com/RS-DBI/download > >If you didn't use that, please try it. > >On Sun, 14 Mar 2004, Ian Long wrote: > > > What do I need to do to load the RMySQL library on Win 2K using version > 1.8.1 > > > > I have Mysql v4.0.16 up and running on the local machine with several > > databases running fine. > > > > Using RGUI I have loaded RMySQL and an appropriate directory structure has > > appeared under > > C:\Program Files\R\rw1081\library\RMySQL > > > > I have added C:\Program Files\R\rw1081\library\RMySQL\inst\libs to my path > > variable so that libmySQL.dll can be found. > > > > If I type library(), then I see RMySQL in the list of available packages. > > > > If I try and load the library, I get > > > library(RMySQL) > > Error in testRversion(descfields) : This package has not been installed > > properly > > See the Note in ?library > > > > Where am I going wrong? > > > > Thanks, > > Ian. > > > > ______________________________________________ > > R-help at stat.math.ethz.ch mailing list > > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html > > > > > >-- >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