[R-sig-DB] problem loading RMySQL

[Miiste@d@Bry@@ m@iii@g oii ep@m@ii@ep@@gov]

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]]