[R] RMySQL LoadLibrary failure: Invalid access to memory location.
topkatz at msn.com
Tue Oct 16 23:06:55 CEST 2007
I'm sorry to revisit a problem that's been much discussed, but I haven't yet
been able to overcome it.
I am running R 2.5.1 on Windows XP Professional 5.1 (Service Pack 2), and I
believe I have MySQL 5.0.45 installed (I downloaded and installed
http://dev.mysql.com/downloads/mysql/5.0.html). Here is what happened when
I tried to install RMySQL:
R version 2.5.1 (2007-06-27)
Copyright (C) 2007 The R Foundation for Statistical Computing
R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.
Natural language support but running in an English locale
R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.
Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.
Content type 'application/zip' length 391364 bytes
package 'RMySQL' successfully unpacked and MD5 sums checked
The downloaded packages are in
C:\Documents and Settings\Talbot\Local
updating HTML package descriptions
Loading required package: RMySQL
Loading required package: DBI
Error in dyn.load(x, as.logical(local), as.logical(now)) :
unable to load shared library
LoadLibrary failure: Invalid access to memory location.
Having looked at some of the previous threads, I hoped that I had the right
MySQL to work with the current version of RMySQL. One of the related posts
says "You do need the RMySQL client DLLs in your PATH." I'm not sure how to
check for this, but it was written in response to a slightly different error
>Error in dyn.load(x, as.logical(local), as.logical(now)) :
> unable to load shared library
> LoadLibrary failure: The specified module could not be found.
>Error: package/namespace load failed for 'RMySQL'
and in my case it doesn't look like it's failing to find the RMySQL.dll.
Once again, I apologize if I missed something obvious, but I'm still stuck
in a rut that others seem to have escaped from. I looked for an alternate
version of the RMySQL package at a site someone suggested in one of the
threads back in August, but that site
) seems to have vanished. Any ideas on what I should do next (other than
shoot myself ;-) ? Thanks!
-- TMK --
More information about the R-help