I can confirm problems with the current mysql 5.0.41: I get > library(RMySQL) Loading required package: DBI Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library 'd:/R/library/RMySQL/libs/RMySQL.dll': LoadLibrary failure: Invalid access to memory location.
I do have a successful build with 5.0.21 (the version I have been testing RODBC against), and have put that on my repository so it will automatically be available to Windows users. The mysql 5.0.41 problem occurs equally with that pre-built RMySQL binary and with a build from the sources. My Linux box is running 5.0.27, and RMySQL works there. On Wed, 13 Jun 2007, Joe W. Byers wrote: > Prof Brian Ripley wrote: >> On Wed, 13 Jun 2007, Ruixin ZHU wrote: >> >>> Dear R-users, >>> >>> It seems that install.packages( ) doesn't work to RMySQL package. >> >> Under Windows, yes. You need the MySQL client libraries for your version >> of MySQL (or something very close to the same version), so the only safe >> way is to install from the sources. The latter is not hard and there are >> instructions in the package. > There are several of us working on updating the RMySQL binary for windows. > Currently one has it compiled with mysql 5.0.18, but can't get it to compile > with 5.0.41. I am having trouble with 5.0.22, 5.0.24, and 5.0.37 mysql > binaries. There seems to be some problems with different versions of mysql. > As soon as we have a tested version of the windows binary for RMySQL, > information for obtaining it will be posted. > > We all appreciate you patiences. > > Thank you > Joe > > >> >> >>> Would anybody have the experience of that? >>> >>> Thanks >>> _____________________________________________ >>> Dr.Ruixin ZHU >>> Shanghai Center for Bioinformation Technology >>> [EMAIL PROTECTED] >>> [EMAIL PROTECTED] >>> 86-21-13040647832 >>> >>> >>> [[alternative HTML version deleted]] >>> >>> ______________________________________________ >>> R-help@stat.math.ethz.ch 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. >>> >> > -- Brian D. Ripley, [EMAIL PROTECTED] 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@stat.math.ethz.ch 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.