Hm, maybe newer R version might help?
RODBC has never failed me.
+1 for RODBC (but ISTR that it was a bitch to get running the first time with getting the ODBC system drivers correctly configured).
RJDBC and java driver for MySQL is the way to handle it. (actually i stopped using native db interfaces in favor of rjdbc - much more convinient, although require java)
This works for me on a 2008 Windows Server.Create an ODBC connection to the MySQL db.library(RODBC)channel <- odbcConnect('connectionName')files <- sqlQuery(channel, "SELECT * FROM `db`.`tbl`" )odbcCloseAll()
RMySQL installation takes a lot of work in Windows.If you are still interested:http://stackoverflow.com/questions/4785933/adding-rmysql-package-to-r-fails