[R-sig-DB] problem loading RMySQL

[Jeffrey Horner]

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