Yes, what happens when I do that is:
R version 2.11.1 (2010-05-31)
Copyright (C) 2010 The R Foundation for Statistical Computing
ISBN 3-900051-07-0
[snip]
> Sys.getenv("MYSQL_USER")
MYSQL_USER
"mf1"
> # As an example. Other env vars are defined.
> library(RMySQL)
Loading required package: DBI
Error : .onLoad failed in loadNamespace() for 'RMySQL', details:
call: utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM",
maxdepth = 2)
error: Registry key 'SOFTWARE\MySQL AB' not found
Error: package/namespace load failed for 'RMySQL'
>
I don't even get to do anything more.
- Jan
On Fri, 05 Nov 2010 17:14 -0200, "Henrique Dallazuanna"
<www...@gmail.com> wrote:
library(RMySQL)
conn <- dbConnect(MySQL(), user = 'user', password =
'password', host = '[1]your_host.com')
Look at [2]http://biostat.mc.vanderbilt.edu/RMySQL for more
information
On Fri, Nov 5, 2010 at 5:04 PM, Jan Theodore Galkowski
<[3]bayesianlo...@acm.org> wrote:
Apologies if this is the wrong place to ask. I'm not aware of
a
mail list devoted to database interfaces. Please direct me if
so.
I am trying to use TSMySQL. It loads RMySQL, and apparent the
CRAN version has an .onLoad script which seeks out the local
MySQL server. If that fails, the package fails to load.
Thing is, I'm trying to access a MySQL database on a remote
machine for which I have authorized access. Anyone know how to
do
this, or suggest where I can find out?
Thanks. I have successfully accessed remote databases using
RODBC. Is that how I need to go?
- Jan
[[alternative HTML version deleted]]
______________________________________________
[4]r-h...@r-project.org mailing list
[5]https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
[6]http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible
code.
--
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O
References
1. http://your_host.com/
2. http://biostat.mc.vanderbilt.edu/RMySQL
3. mailto:bayesianlo...@acm.org
4. mailto:R-help@r-project.org
5. https://stat.ethz.ch/mailman/listinfo/r-help
6. http://www.R-project.org/posting-guide.html
--
Jan Theodore Galkowski (o°)
607.239.1834 [mobile]
607.239.1834 [home]
617.444.4995 [work]
bayesianlo...@acm.org
http://www.linkedin.com/in/deepdevelopment
"Eppur si muove." --Galilei
[[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.
