Message-ID: <OF3CC9BB0E.6C8CC124-ON852575A8.005F1E47-852575A8.0060A1AA@epamail.epa.gov>
Date: 2009-04-30T17:35:51Z
From: Miiste@d@Bry@@ m@iii@g oii ep@m@ii@ep@@gov
Subject: problem loading RMySQL
In-Reply-To: <49F9D8A1.5050007@vanderbilt.edu>
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
[[alternative HTML version deleted]]