[R-sig-DB] problem loading RMySQL

[尧 苏]

Hi Jeff:�� I'd like to use the RMySQL package that you administer but am 
having trouble loading it.�� I can download and install the package but 
can't load it.  Below is the output from my attempt.  I will appreciate 
any help you can give me on this.���� Thanks.
The result of following codes are also attached:
sessionInfo()
.libPaths()
Sys.getenv('MYSQL_HOME')
utils::readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)

> utils:::menuInstallPkgs()
--- Please select a CRAN mirror for use in this session ---
also installing the dependency ���DBI���
trying URL 'http://ftp.ctex.org/mirrors/CRAN/bin/windows/contrib/2.10/DBI_0.2-4.zip'
Content type 'application/zip' length 375508 bytes (366 Kb)
opened URL
downloaded 366 Kb
trying URL 'http://ftp.ctex.org/mirrors/CRAN/bin/windows/contrib/2.10/RMySQL_0.7-4.zip'
Content type 'application/zip' length 284408 bytes (277 Kb)
opened URL
downloaded 277 Kb
package 'DBI' successfully unpacked and MD5 sums checked
package 'RMySQL' successfully unpacked and MD5 sums checked
The downloaded packages are in
�������������� C:\Documents and Settings\su\Local Settings\Temp\RtmpUPYJh5\downloaded_packages
> library(RMySQL)
Loading required package: DBI
Error in if (utils::file_test("-d", MySQLhome)) break : 
�� argument is of length zero
Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
Error: package/namespace load failed for 'RMySQL'

> sessionInfo()
R version 2.10.0 (2009-10-26) 
i386-pc-mingw32 
locale:
[1] LC_COLLATE=Chinese_People's Republic of China.936 
[2] LC_CTYPE=Chinese_People's Republic of China.936���� 
[3] LC_MONETARY=Chinese_People's Republic of China.936
[4] LC_NUMERIC=C�������������������������������������������������������������������������� 
[5] LC_TIME=Chinese_People's Republic of China.936������ 
attached base packages:
[1] stats�������� graphics�� grDevices utils�������� datasets�� methods�� 
[7] base�������� 
other attached packages:
[1] DBI_0.2-4���� RODBC_1.3-1
loaded via a namespace (and not attached):
[1] tools_2.10.0
> .libPaths()
[1] "D:/PROGRA~1/R/R-210~1.0/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"

$`MySQL Server 5.1`
$`MySQL Server 5.1`$DataLocation
[1] "C:\\Documents and Settings\\All Users\\Application Data\\MySQL\\MySQL Server 5.1\\"
$`MySQL Server 5.1`$FoundExistingDataDir
[1] "0"
$`MySQL Server 5.1`$Location
[1] "D:\\MySQL\\"
$`MySQL Server 5.1`$Version
[1] "5.1.37"



      ___________________________________________________________ 
  ��������������������������������������������������� 
http://card.mail.cn.yahoo.com/
	[[alternative HTML version deleted]]