RMySQL installation problem

Prof Brian Ripley schrieb:
On Thu, 15 Nov 2007, Tao Shi wrote:

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.

I tried to install the package too, and I can confirm that there is the
same error.
the ...\library\mysql\libs is in the path
I copied an executable file into the directory named test123.exe
and used Start-> execute test123.exe
The program was executed

controll test:
I deleted the exeutable file
and used Start-> execute test123.exe  again
result
file not found.

so the path is ok but it isn't working

Did I miss something else?
Regards Knut
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
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.

Christian Schulz schrieb:
I think you should use the newest DBI Version with 2.6.1.
regards, christian
I run *actualice packages*,
 this should update to the newest DBI, shouldn't it?
Knut
Christian Schulz schrieb:

I think you should use the newest DBI Version with 2.6.1.
regards, christian

I run *actualice packages*,
 this should update to the newest DBI, shouldn't it?
Knut

I'm not sure, perhaps you are on an old "branch"? Try  for 2.6.1:
http://umfragen.sowi.uni-mainz.de/CRAN/bin/windows/contrib/2.6/DBI_0.2-4.zip
http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.6/RMySQL_0.6-0.zip

good luck,
Christian
First question: is this the right mailing list to discuss installation
problems?

if yes:
(Windows XP professional environment )
Installing a second  packege after the first causes an error:

-----------------------------------------------------------------------------------------------------------------
utils:::menuInstallLocal()
package 'RMySQL' successfully unpacked and MD5 sums checked
updating HTML package descriptions
utils:::menuInstallLocal()
package 'DBI' successfully unpacked and MD5 sums checked
Warning: unable to move temporary installation
'C:\Programme\R\R-2.6.1\library\file3d6c4ae1\DBI' to
'C:\Programme\R\R-2.6.1\library\DBI'
updating HTML package descriptions
-----------------------------------------------------------------------------------------------------------------

but installing DBI first causes the same error but than with RMySQL:

-----------------------------------------------------------------------------------------------------------------
utils:::menuInstallLocal()
package 'DBI' successfully unpacked and MD5 sums checked
updating HTML package descriptions
utils:::menuInstallLocal()
package 'RMySQL' successfully unpacked and MD5 sums checked
Warnung: unable to move temporary installation
'C:\Programme\R\R-2.6.1\library\file3d6c4ae1\RMySQL' to
'C:\Programme\R\R-2.6.1\library\RMySQL'
updating HTML package descriptions
-----------------------------------------------------------------------------------------------------------------
The directory C:\Programme\R\R-2.6.1\library\file3d6c4ae1\ is not
present ...

I tried a several times to restart the Rgui no without saving the
workspace and tried to install the package again no change.
The last time I saved the Workspace and got a success after installing
the package:

but the initial problem is still there
 library(DBI)
 library(RMySQL)
Error in dyn.load(file, ...) :
  cannot load shared library
'C:/Programme/R/R-2.6.1/library/RMySQL/libs/RMySQL.dll'
LoadLibrary failure:  module not found (Remark translated message)

Fehler: Laden von Paket/Namensraum f?r 'RMySQL' fehlgeschlagen

Regards Knut