[R] Problem installing RMySQL package!

[S Ellison]

> -----Original Message-----
> From: r-help-bounces at r-project.org 
> [mailto:r-help-bounces at r-project.org] On Behalf Of AGGARWAL, 
> NEERAJ (NEERAJ)
> Sent: 14 March 2012 05:14
> To: r-help at r-project.org
> Subject: [R] Problem installing RMySQL package!
> 
> I am facing issues while installing RMySQL package on 
> windows(32 bit) installation of R-Project.
> I am getting the following warning messages.
> 
> Warning messages:
> 1: running command 'C:/PROGRA~1/R/R-213~1.2/bin/i386/R CMD 
> INSTALL -l "C:/Program Files/R/R-2.13.2/library"   
> D:\DOCUME~1\nagga002\LOCALS~1\Temp\RtmpLZndlE/downloaded_packa
> ges/RMySQL_0.9-3.tar.gz' had status 1
> 2: In install.packages("RMySQL", type = "source") :
>   installation of package 'RMySQL' had non-zero exit status

> Is RTools something different from RProject. 
Read 'R installation and administration' in your R Help system. That will tell you what R Tools is/are and where to get them.

In relation to accessing a MySQL database, you could also consider installing RODBC (which installs from binary unsinf install.packages()), registering your MySQL database as an ODBC data source in Windows and then using RODBC's query facilities. That certainly works for ordinary SELECTS, INSERTS and UPDATES, and does not require RMySQL. 

S*******************************************************************
This email and any attachments are confidential. Any use...{{dropped:8}}