R help - Sep 2007 - I can't do it again on an other PC : R+RMySQL ->error loading dll

Hello,

Some weeks ago, thanks to you, I managed to install R, to connect to a local
MySQL Database and to launch some queries with a script written with Tinn-R. 
My script is now ok and would like to test it with the "real"
database.
I did the same installation of R, DBI package and RMySQL package I did on my
PC (I wrote everything I did in order to make it easy ...) but when I type
"libray(RMySQL), I got an error message (see below).

I tried to copy libmySQL.dll and RMySQL.dll in \system\ (like on my PC), in
\system32\, in \R\bin\ and to change the path. But always the same error
message ...

Has anybody any other solution I can try ?
Thanks in advance,
Ptit Bleu.   


-------------------------------------------------------------
R version 2.5.1 (2007-06-27)
Copyright (C) 2007 The R Foundation for Statistical Computing
ISBN 3-900051-07-0

R est un logiciel libre livr? sans AUCUNE GARANTIE.
Vous pouvez le redistribuer sous certaines conditions.
Tapez 'license()' ou 'licence()' pour plus de d?tails.

R est un projet collaboratif avec de nombreux contributeurs.
Tapez 'contributors()' pour plus d'information et
'citation()' pour la fa?on de le citer dans les publications.

Tapez 'demo()' pour des d?monstrations, 'help()' pour l'aide
en ligne ou 'help.start()' pour obtenir l'aide au format HTML.
Tapez 'q()' pour quitter R.
> library()
> .libPaths()
[1] "C:/R/library"
> library(DBI)
> library(RMySQL)
Error in dyn.load(x, as.logical(local), as.logical(now)) : 
        impossible de charger la biblioth?que partag?e
'C:/R/library/RMySQL/libs/RMySQL.dll':
  LoadLibrary failure:  L'acc?s ? cet emplacement de la m?moire n'est
pas
valide.


Erreur : le chargement du package / espace de noms a ?chou? pour
'RMySQL'
> 
------------------------------------
-- 
View this message in context:
http://www.nabble.com/I-can%27t-do-it-again-on-an-other-PC-%3A-R%2BRMySQL--%3Eerror-loading-dll-tf4414597.html#a12592576
Sent from the R help mailing list archive at Nabble.com.

Hi,

just to say that I "solved" my problem. I wrote "solved"
because all I did
was to uninstall R and the DBI and RMySQL libraries and then install
everything again.
The only change is that I used another RMySQL.zip file found at this address
:
http://www.bioconductor.org/packages/2.0/extra/bin/windows/contrib/2.5/RMySQL_0.6-0.zip
(the file is much bigger than the one I used on my PC : 1064 Mo instead of
383 Mo).

I installed the DBI and the RMySQL packages from R (intallation from .zip
file).
I typed "library(RMySQL)" and it directly worked, without copying the
.dll
in some other places.

Maybe it can help some people. 

Have a nice day,
Ptit Bleu.
-- 
View this message in context:
http://www.nabble.com/I-can%27t-do-it-again-on-an-other-PC-%3A-R%2BRMySQL--%3Eerror-loading-dll-tf4414597.html#a12610089
Sent from the R help mailing list archive at Nabble.com.