Hi. A colleague of mine figured out how to get the RMySQL 0.6 package to load properly in our environment with MySQL 5.0.45. Every time I tried to load the RMySQL library in R 2.5.1 I was getting an error message: LoadLibrary failure: Invalid access to memory location.
We did the following: First obtain RMySQL 0.5-7, which can be found at http://stat.bell-labs.com/RS-DBI/download/index.html, but don't overwrite the RMySQL 0.6 folder with this, place it in a separate location. Then, from the RMySQL_0.5-7 libs sub-folder, grab the file libMySQL.dll. This is a MySQL dll that is not included in the RMySQL_0.6 libs sub-folder. Then copy this version of libMySQL.dll, dated January 28th, 2006, to the system folder, C:\WINDOWS\system32, overwriting the copy that was there (I didn't see which one it was, but the libMySQL.dll in the MySQL Server 5.0\bin sub-folder is dated July 6th, 2007). Now the RMySQL library loads correctly in R 2.5.1 on my Windows XP machine. I'm keeping my fingers crossed that we haven't violated some other universal edict... -- TMK -- 212-460-5430 home 917-656-5351 cell ______________________________________________ R-help@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.
