Hi,
I have two questions:

1)      Since I switched to Windows 2007 and downloaded the current R version 
(2.12.1; 2010-12-16) for Windows 7 a month ago, I cannot down load packages 
through the GUI drop down menu. I get: Warning: unable to access index for 
repository http://cran.cnr.Berkeley.edu/bin/windows/contrib/2.12

Warning: unable to access index for repository 
http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.12

Warning messages:

1: In open.connection(con, "r") :

  unable to connect to 'cran.r-project.org' on port 80.

In fact, just to assign the CRAN location in the drop down menu takes forever. 
From web searches, the first check is to see if you have internet access. I do 
and can download the packages directly to my hard drive and load them 
indirectly into R by using library(MASS, lib.loc="C:\\Users\\R\\R packages"). 
This is starting to become a pain. Any suggestions on looking at potential 
security settings that I might need to deactiviate or any other issues?

2)      Any suggestions how I can connect to a MySQL database through windows 
using R. I found this example on the web, but there is not a package for RMYSQL 
for windows. Bugger!!!

library(RMySQL)

drv = dbDriver("MySQL")

con = dbConnect(drv,host="mars",dbname="sat133",user="sat133",pass="T0pSecr3t")

album = dbGetQuery(con,statement="select * from tasks")





Thanks for any input!!

Sarah

        [[alternative HTML version deleted]]

______________________________________________
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.

Reply via email to