On 18/07/2009 3:04 PM, David Lubbers wrote:
With good and faithful python remote database queries look something
like this:
url.urlopen("username/pssw...@host",query)
where query is something like "select * from table where ...."
Does R support queries on remote hosts with username and password?
What does a simple example look like?
It depends on what kind of database you're connecting to. If you have
an ODBC connection set up they're pretty standardized, and it would be
something like
library(RODBC)
channel <- odbcConnect("dsn", uid="username", pwd="password")
sqlQuery(channel, query)
Duncan Murdoch
______________________________________________
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.
