did you try the RODBC package as well. Regards
Ajay Websites- http://decisionstats.com http://dudeofdata.com Linkedin- www.linkedin.com/in/ajayohri On Sat, Nov 13, 2010 at 9:22 AM, Santosh Srinivas <santosh.srini...@gmail.com> wrote: > Dear Group, > > I'm having lots of problems getting RMySQL on a 64 bit machine. I followed > all instructions available but couldn't get it working yet! Please help. > See the output below. > > I did a install of RMySQL binary from the revolution cran source. It seems > to have unpacked fine but gives this error when I call RMySQL > Error: package 'RMySQL' is not installed for 'arch=x64' > > > I set this environment variable on the windows path >> Sys.getenv('MYSQL_HOME') > MYSQL_HOME > "C:/Program Files/MySQL/MySQL Server 5.0" > >> install.packages('RMySQL',type='source') > trying URL > 'http://cran.revolutionanalytics.com/src/contrib/RMySQL_0.7-5.tar.gz' > Content type 'application/x-gzip' length 160769 bytes (157 Kb) > opened URL > downloaded 157 Kb > > * installing *source* package 'RMySQL' ... > checking for $MYSQL_HOME... C:/Program Files/MySQL/MySQL Server 5.0 > test: Files/MySQL/MySQL: unknown operand > ERROR: configuration failed for package 'RMySQL' > * removing 'C:/Revolution/Revo-4.0/RevoEnt64/R-2.11.1/library/RMySQL' > * restoring previous > 'C:/Revolution/Revo-4.0/RevoEnt64/R-2.11.1/library/RMySQL' > > The downloaded packages are in > > 'C:\Users\Administrator\AppData\Local\Temp\2\RtmpvGgrzb\downloaded_packages' > Warning message: > In install.packages("RMySQL", type = "source") : > installation of package 'RMySQL' had non-zero exit status >> sessionInfo() > R version 2.11.1 (2010-05-31) > x86_64-pc-mingw32 > > locale: > [1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United > States.1252 LC_MONETARY=English_United States.1252 LC_NUMERIC=C > > [5] LC_TIME=English_United States.1252 > > attached base packages: > [1] stats graphics grDevices utils datasets methods base > > other attached packages: > [1] Revobase_4.0.0 RevoScaleR_1.0-0 lattice_0.18-8 > > loaded via a namespace (and not attached): > [1] grid_2.11.1 tools_2.11.1 > > ______________________________________________ > 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. > ______________________________________________ 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.
