Hi R users,
I have been trying to install and use RMySQL on Windows98 for
MySQL3.23.55-max using the pulldown menu. I am getting the following errors.
I read the doc and some archived mails about a similar problem on unix like
systems. Still can't get it to work. Some info below that may indicated
where
the problem is:
* The directory RMySQL\libs is empty---I was not expecting this.
* There is a file "README.windows" in RMySQL directory which suggests
some
changes using the re-import utility "reimp", available at
http://mefriss1.swan.ac.uk/~jfonseca/gnu-win32/software/reimp/index.html
This file is missing at this location. Instead there is a note stating that
it is included in MinGW distribution. I installed this, but did not find this
file.
* Below is the info from the installation and loading the library:
> {a <- CRAN.packages()
+ install.packages(select.list(a[,1],,TRUE), .libPaths()[1], available=a)}
trying URL `http://cran.r-project.org/bin/windows/contrib/PACKAGES'
Content type `text/plain; charset=iso-8859-1' length 8948 bytes
opened URL
downloaded 8948 bytes
trying URL `http://cran.r-project.org/bin/windows/contrib/RMySQL.zip'
Content type `application/zip' length 322573 bytes
opened URL
downloaded 315Kb
Delete downloaded files (y/N)? y
updating HTML package descriptions
Warning message:
DLL attempted to change FPU control word from 8001f to 9001f
> library(RMySQL)
Loading required package: methods
Error in dyn.load(x, as.logical(local), as.logical(now)) :
unable to load shared library
"H:/PROGRAMLOCAL/RW1062/library/RMySQL/libs/RMySQL.dll":
LoadLibrary failure: One of the library files needed to run this
application cannot be found.
Error in library(RMySQL) : .First.lib failed>
-at
*********************************************************
Prediction is very difficult, especially about the future.
-- Niels Bohr
The message does not say that RMySQL is empty, indeed finds a DLL there, so please check your facts and the R-help archives for *yesterday*. I suspect all you need to do is to put .../library/RMySQL/lib in your path. On Sun, 16 Feb 2003 TyagiAnupam at aol.com wrote:> Hi R users, > > I have been trying to install and use RMySQL on Windows98 for > MySQL3.23.55-max using the pulldown menu. I am getting the following errors. > I read the doc and some archived mails about a similar problem on unix like > systems. Still can't get it to work. Some info below that may indicated where > the problem is: > * The directory RMySQL\libs is empty---I was not expecting this. > * There is a file "README.windows" in RMySQL directory which suggests some > changes using the re-import utility "reimp", available at > > http://mefriss1.swan.ac.uk/~jfonseca/gnu-win32/software/reimp/index.html > This file is missing at this location. Instead there is a note stating that > it is included in MinGW distribution. I installed this, but did not find this > file. > * Below is the info from the installation and loading the library: > > > {a <- CRAN.packages() > + install.packages(select.list(a[,1],,TRUE), .libPaths()[1], available=a)} > trying URL `http://cran.r-project.org/bin/windows/contrib/PACKAGES' > Content type `text/plain; charset=iso-8859-1' length 8948 bytes > opened URL > downloaded 8948 bytes > > trying URL `http://cran.r-project.org/bin/windows/contrib/RMySQL.zip' > Content type `application/zip' length 322573 bytes > opened URL > downloaded 315Kb > > > Delete downloaded files (y/N)? y > > updating HTML package descriptions > Warning message: > DLL attempted to change FPU control word from 8001f to 9001f > > library(RMySQL) > Loading required package: methods > Error in dyn.load(x, as.logical(local), as.logical(now)) : > unable to load shared library > "H:/PROGRAMLOCAL/RW1062/library/RMySQL/libs/RMySQL.dll": > LoadLibrary failure: One of the library files needed to run this > application cannot be found. > Error in library(RMySQL) : .First.lib failed > > > -at > > ********************************************************* > Prediction is very difficult, especially about the future. > -- Niels Bohr > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > http://www.stat.math.ethz.ch/mailman/listinfo/r-help >-- 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
Thanks. The file is indeed there. By default Windows Explorer makes the *.dll files invisible. The file seem to be in a branch of the default library. I am missing something here.> .libPaths()[1] "H:/PROGRAMLOCAL/RW1062/library"> library(RMySQL)Loading required package: methods Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library "H:/PROGRAMLOCAL/RW1062/library/RMySQL/libs/RMySQL.dll": LoadLibrary failure: One of the library files needed to run this application cannot be found. Error in library(RMySQL) : .First.lib failed In a message dated 2/16/03 3:30:00 AM Eastern Standard Time, ripley@stats.ox.ac.uk writes:> The message does not say that RMySQL is empty, indeed finds a DLL there, > so please check your facts and the R-help archives for *yesterday*. > I suspect all you need to do is to put .../library/RMySQL/lib in your > path. > > On Sun, 16 Feb 2003 TyagiAnupam@aol.com wrote: > > > Hi R users, > > > > I have been trying to install and use RMySQL on Windows98 for > > MySQL3.23.55-max using the pulldown menu. I am getting the following > errors. > > I read the doc and some archived mails about a similar problem on unix > like > > systems. Still can''t get it to work. Some info below that may indicated > where > > the problem is: > > * The directory RMySQL\libs is empty---I was not expecting this. > > * There is a file "README.windows" in RMySQL directory which suggests > some > > changes using the re-import utility "reimp", available at > > > > http://mefriss1.swan.ac.uk/~jfonseca/gnu-win32/software/reimp/index.html > > This file is missing at this location. Instead there is a note stating > that > > it is included in MinGW distribution. I installed this, but did not find > this > > file. > > * Below is the info from the installation and loading the library: > > > > > {a <- CRAN.packages() > > + install.packages(select.list(a[,1],,TRUE), .libPaths()[1], > available=a)} > > trying URL `http://cran.r-project.org/bin/windows/contrib/PACKAGES'' > > Content type `text/plain; charset=iso-8859-1'' length 8948 bytes > > opened URL > > downloaded 8948 bytes > > > > trying URL `http://cran.r-project.org/bin/windows/contrib/RMySQL.zip'' > > Content type `application/zip'' length 322573 bytes > > opened URL > > downloaded 315Kb > > > > > > Delete downloaded files (y/N)? y > > > > updating HTML package descriptions > > Warning message: > > DLL attempted to change FPU control word from 8001f to 9001f > > > library(RMySQL) > > Loading required package: methods > > Error in dyn.load(x, as.logical(local), as.logical(now)) : > > unable to load shared library > > "H:/PROGRAMLOCAL/RW1062/library/RMySQL/libs/RMySQL.dll": > > LoadLibrary failure: One of the library files needed to run this > > application cannot be found. > > Error in library(RMySQL) : .First.lib failed > > > > > -at > > > > ********************************************************* > > Prediction is very difficult, especially about the future. > > -- Niels Bohr > > > > ______________________________________________ > > R-help@stat.math.ethz.ch mailing list > > http://www.stat.math.ethz.ch/mailman/listinfo/r-help > > > > -- > Brian D. Ripley, ripley@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 >********************************************************* Prediction is very difficult, especially about the future. -- Niels Bohr ********************************************************* [[alternate HTML version deleted]]
In a message dated 2/16/03 6:24:53 AM Eastern Standard Time, ligges@statistik.uni-dortmund.de writes:> TyagiAnupam@aol.com wrote: > > > > Thanks. The file is indeed there. By default Windows Explorer makes the > *.dll > > files invisible. The file seem to be in a branch of the default library. > I am > > missing something here. > > > .libPaths() > > [1] "H:/PROGRAMLOCAL/RW1062/library" > > > library(RMySQL) > > Loading required package: methods > > Error in dyn.load(x, as.logical(local), as.logical(now)) : > > unable to load shared library > > "H:/PROGRAMLOCAL/RW1062/library/RMySQL/libs/RMySQL.dll": > > LoadLibrary failure: One of the library files needed to run this > > application cannot be found. > > Error in library(RMySQL) : .First.lib failed > > > You missed to read README.windows in the packages'' directory and Brian > Ripley''s mail carefully (citing the latter): > "I suspect all you need to do is to put .../library/RMySQL/lib in your > path", > where path means the *environment variable* of your OS called PATH. > > If you don''t know how to set environment variables, please contact the > IT stuff of your department or the OS manuals / support. > > Uwe Ligges >Thanks. Just did it in Autoexec.bat file. It seems to be working well. While loading the library there is still a warning. Is this something to worry about?> {pkg <- select.list(sort(.packages(all.available = TRUE)))+ if(nchar(pkg)) library(pkg, character.only=TRUE)} Loading required package: methods Warning message: DLL attempted to change FPU control word from 8001f to 9001f>********************************************************* Prediction is very difficult, especially about the future. -- Niels Bohr ********************************************************* [[alternate HTML version deleted]]