[R] RMySQL installing problems

[Prof Brian Ripley]

You do need the RMySQL client DLLs in your PATH.  Also make sure that your 
MySQL version is not one listed as problematic at

http://www.stats.ox.ac.uk/pub/RWin/ReadMe

On Fri, 28 Sep 2007, andreiabb wrote:

>
> Dear forum,
>
> I'm trying to install RMySQL but I'm having problems in loading it, here is
> the message that I'm getting in R
> install.packages("RMySQL", dependencies=TRUE)
> trying URL
> 'http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.5/RMySQL_0.6-0.zip'
> Content type 'application/zip' length 391364 bytes
> opened URL
> downloaded 382Kb
>
> package 'RMySQL' successfully unpacked and MD5 sums checked
>
> The downloaded packages are in
>        C:\TEMP\RtmpqsmLsb\downloaded_packages
> updating HTML package descriptions
>
>> local({pkg <- select.list(sort(.packages(all.available = TRUE)))
> + if(nchar(pkg)) library(pkg, character.only=TRUE)})
> Error in dyn.load(x, as.logical(local), as.logical(now)) :
>        unable to load shared library
> 'C:/PROGRA~1/R/R-25~1.1/library/RMySQL/libs/RMySQL.dll':
>  LoadLibrary failure:  The specified module could not be found.
>
>
> Error: package/namespace load failed for 'RMySQL'
>
>
> Can someone give me a tip?
>
> Thanks
>
> Regards
>
> Andreia Fonseca
>
> PhD candidate
> Wageningen University
>
> Animal Breeding and Genomics Centre
>
>    Marijkweg 40
>
>    P.O. Box 338
>
>    6700 AH Wageningen
>
>  Tel: +31 (0)  317483194
>
>
>

-- 
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