List,

I am still unable to compile RMySQL on XP and would appreciate any assistance anyone could provide.

I know that setting up RMySQL on win32 is not easy.  The installation instructions are supposedly contained in ../src/README.win.  They give instructions on creating a file, libmysql.a, which I was able to do successfully.

Here is where the instructions basically break down.  The creation of this file all occurs in \MySQL\..\lib\opt, after which the reader is instructed to copy libmysql.a to ..\lib\opt (huh?  You mean, where it already is?).  Then the reader is instructed to build the binaries with Rcmd build --binary RMySQL.

>From the windows command shell, the result is:

C:\>Rcmd build --binary RMySQL
* checking for file 'RMySQL/DESCRIPTION' ... OK
* preparing 'RMySQL':
* checking DESCRIPTION meta-information ...'sh' is not recognized as an internal  or external command, operable program or batch file.
 OK
* cleaning src
'sh' is not recognized as an internal or external command, operable program or batch file.
Error: cannot open file 'c:/TEMP/Rout381268676' for reading

Apparently R is trying to call some shell script (from the windows prompt??) so I attempted this in cygwin.  Results:

Can't locate R/Dcf.pm in @INC (@INC contains: c \PROGRA~1\R\R-24~1.1\share\perl; /usr/lib/perl5/5.8/cygwin /usr/lib/perl5/5.8 /usr/lib/perl5/site_perl/5.8/cygwin /usr/lib/perl5/site_perl/5.8 /usr/lib/perl5/site_perl/5.8/cygwin /usr/lib/perl5/site_perl/5.8 /usr/lib/perl5/vendor_perl/5.8/cygwin /usr/lib/perl5/vendor_perl/5.8 /usr/lib/perl5/vendor_perl/5.8/cygwin /usr/lib/perl5/vendor_perl/5.8 .) at c:\PROGRA~1\R\R-24~1.1/bin/build line 29.
BEGIN failed--compilation aborted at c:\PROGRA~1\R\R-24~1.1/bin/build line 29.

Dcf.pm is actually located in C:\Program Files\R\R-2.4.1\share\perl\R.  I wonder if the variable @INC is simply incorrect (it's looking under R-24~1.1, not sure if the truncated value is actually correct) but I have no idea in which file it may be located.

Anyone have any ideas?
I have installed mingw-utils while attempting to get this up and running, if it matters.

If there is a simply better solution that I should try, I would appreciate hearing about it as well.  All I really need to do at this point is send select and join queries to the local server--perhaps I should just install RSQLite from CRAN?

Thanks in advance,

Pete

 
---------------------------------
Be a PS3 game guru.

	[[alternative HTML version deleted]]

