[R-sig-DB] problem loading RMySQL
Miiste@d@Bry@@ m@iii@g oii ep@m@ii@ep@@gov
Miiste@d@Bry@@ m@iii@g oii ep@m@ii@ep@@gov
Thu Apr 30 19:35:51 CEST 2009
Hi Jeff: I have MySQL 5.1 up an running on my machine and I am using it
so I don't think this is the issue. It shouldn't matter but, I used the
XAMPP build to install MySQL instead of using the source binaries. I also
have a MySQL ODBC connector installed so I can use MySQL with open office.
So where do I go from here?
Cheers, Bryan
milstead.bryan using epa.gov
(401) 782-3015
From:
Jeffrey Horner <jeff.horner using vanderbilt.edu>
To:
Bryan Milstead/NAR/USEPA/US using EPA
Cc:
"r-sig-db using stat.math.ethz.ch" <r-sig-db using stat.math.ethz.ch>
Date:
04/30/2009 12:58 PM
Subject:
Re: problem loading RMySQL
Milstead.Bryan using epamail.epa.gov wrote on 04/30/2009 11:56 AM:
>
> Hi Jeff: thanks for getting back to me so quickly.
>
> Here is the output::
>
> > sessionInfo()
> R version 2.8.1 (2008-12-22)
> i386-pc-mingw32
>
> locale:
> LC_COLLATE=English_United States.1252;LC_CTYPE=English_United
> States.1252;LC_MONETARY=English_United
> States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252
>
> attached base packages:
> [1] stats graphics grDevices datasets tcltk utils methods
> base
>
> other attached packages:
> [1] ineq_0.2-8 foreign_0.8-34 DBI_0.2-4 svSocket_0.9-43
> svMisc_0.9-46 TinnR_1.0.3
> [7] R2HTML_1.59-1 Hmisc_3.5-2
>
> loaded via a namespace (and not attached):
> [1] cluster_1.11.13 grid_2.8.1 lattice_0.17-22 tools_2.8.1
> > .libPaths()
> [1]
>
"//AA.AD.EPA.GOV/ORD/NAR/USERS/EC2/wmilstea/NETMYD~1/PORTAB~2/R/R-28~1.1/library"
>
> > Sys.getenv('MYSQL_HOME')
> MYSQL_HOME
> ""
> > utils::readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)
> $`MySQL Connector/ODBC 5.1`
> $`MySQL Connector/ODBC 5.1`$Version
> [1] "5.1.5"
>
See http://biostat.mc.vanderbilt.edu/RMySQL
You haven't installed the MySQL client libraries.
Jeff
[[alternative HTML version deleted]]
More information about the R-sig-DB
mailing list