[R-sig-DB] RMySQL error under Windows Server 2008 64-bit

[Michael Styer]

Hello,

I'm trying to use RMySQL under Windows Server 2008 64-bit and I 
encounter the following errors. MySQL version 5.0.67 is installed and 
running.

Initially when loading RMySQL I got this error:

 > library("RMySQL")
Error in fun(...) : MySQL is not installed according to a Registry search
In addition: Warning message:
package 'RMySQL' was built under R version 2.8.1
Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
Error: package/namespace load failed for 'RMySQL'

Then I tried setting the environment variable MYSQL_HOME="C:\\Program 
Files\\MySQL\\MySQL Server 5.0\\", which is the installation directory 
for the MySQL installation on this server. After that, when loading 
RMySQL I get this error:

 > library("RMySQL")
Loading required package: DBI
Error : MYSQL_HOME was set but does not point to a directory
In addition: Warning message:
package 'RMySQL' was built under R version 2.8.1
Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
Error: package/namespace load failed for 'RMySQL'

What else should I try to get RMySQL to load correctly?

Thanks very much.

Michael