Hi List, I'm running R2.5.1 on WinXP. Downloaded RMySQL_0.6-0.zip from http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.6/ and the installation seemed fine. However, when I tried to load the package, the error occured:> utils:::menuInstallLocal()package 'RMySQL' successfully unpacked and MD5 sums checked updating HTML package descriptions> library(RMySQL)Loading required package: DBI 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' ## However, I can see the .dll file is there from window's explorer!! There was also a pop windows says: "R Console: Rgui.exe-Unable To Locate Component This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix the problem." I tried the re-installation. It didn't work. The "DBI" package I have is version 0.2-4, just in case. thanks, ...Tao _________________________________________________________________ Climb to the top of the charts!? Play Star Shuffle:? the word scramble challenge with star power. t
On Thu, 15 Nov 2007, Tao Shi wrote:> > Hi List, > > I'm running R2.5.1 on WinXP. Downloaded RMySQL_0.6-0.zip from http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.6/ and the installation seemed fine. However, when I tried to load the package, the error occured: > > >> utils:::menuInstallLocal() > package 'RMySQL' successfully unpacked and MD5 sums checked > updating HTML package descriptions >> library(RMySQL) > Loading required package: DBI > 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' > > ## However, I can see the .dll file is there from window's explorer!!The 'specified module' was specified in the popup! (Windows' users should be used to the arcaneness of the error messages.) Assuming you actually have MySQL installed, you need to make sure libmysql.dll is on the PATH. It's in the mysql\bin directory, so installing MySQL would normally put it on the PATH.> There was also a pop windows says: > > "R Console: Rgui.exe-Unable To Locate Component > This application has failed to start because LIBMYSQL.dll was not found. > Re-installing the application may fix the problem." > > I tried the re-installation. It didn't work. The "DBI" package I have > is version 0.2-4, just in case.-- 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 think you should use the newest DBI Version with 2.6.1. regards, christian> It seems to be an 2.6.1 Version problem. > I tried to use > http://umfragen.sowi.uni-mainz.de/CRAN/bin/windows/contrib/2.2/DBI_0.1-10.zip > with 2.6.1 and 2.2.0 > It is working with 2.2.0 (build under R Version 2.2.1) > > Knut > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > >