[R-sig-DB] connecting to remote database using RMySQL, from WinXP Pro

[Jan Theodore Galkowski]

(Sorry, cross-posted from R-Help to more appropriate venue.)

On Fri, 05 Nov 2010 19:32 +0000, "Jan Theodore Galkowski"
<bayesianlogic using acm.org> wrote:

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"
<wwwhsd using 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]bayesianlogic using 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



[snip]

References

1. http://your_host.com/
2. http://biostat.mc.vanderbilt.edu/RMySQL
3. mailto:bayesianlogic using acm.org
--
  Jan Theodore Galkowski  (o�)

  607.239.1834 [mobile]
  607.239.1834 [home]
  617.444.4995 [work]

 bayesianlogic using acm.org
 http://www.linkedin.com/in/deepdevelopment


 "Eppur si muove." --Galilei



	[[alternative HTML version deleted]]