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
Hm, maybe newer R version might help?
ReplyDeleteRODBC has never failed me.
ReplyDelete+1 for RODBC (but ISTR that it was a bitch to get running the first time with getting the ODBC system drivers correctly configured).
ReplyDeleteRJDBC and java driver for MySQL is the way to handle it.
ReplyDelete(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.
ReplyDeleteCreate 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.
ReplyDeleteIf you are still interested:
http://stackoverflow.com/questions/4785933/adding-rmysql-package-to-r-fails