problem loading RMySQL
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 at epa.gov (401) 782-3015 From: Jeffrey Horner <jeff.horner at vanderbilt.edu> To: Bryan Milstead/NAR/USEPA/US at EPA Cc: "r-sig-db at stat.math.ethz.ch" <r-sig-db at stat.math.ethz.ch> Date: 04/30/2009 12:58 PM Subject: Re: problem loading RMySQL Milstead.Bryan at 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