[R] Installing RMySQL -- 64-bit Windows 7

[z2.0]

Trying to install RMySQL on 64-bit Windows 7.

Using R-2.14.2 with Rtools214 and MySQL Server 5.5.

Read through several step-by-steps of RMySQL source installation.

Troubleshooting:
 - Copied libmysql.dll to R-2.14.2/bin AND R-2.14.2/bin/i386.
 - Copied libmysql.dll and libmysql.lib to MySQL Server 5.5\lib\opt.
 - Entered MYSQL_HOME=C:\Program Files\MySQL\MySQL Server 5.5 into
Renviron.site, saved to R\R-2.14.2\etc.

My instances of common problems:

Sys.getenv('MySQL_HOME') [1] "C:\Program Files\MySQL\MySQL Server 5.5\"

install.packages('RMySQL', type = 'source') Installing package(s) ... ...
RS-DBI.c:1:0: sorry, unimplemented: 64-bit mode not compiled in make:
[RS-DBI.o] Error 1* ERROR: compilation failed for package 'RMySQL' ...

I'm guessing my problem lies in the '64-bit mode...' message, but I'm not
sure.

Thoughts?

--
View this message in context: http://r.789695.n4.nabble.com/Installing-RMySQL-64-bit-Windows-7-tp4466352p4466352.html
Sent from the R help mailing list archive at Nabble.com.