On 1/12/2009 1:02 PM, auburneconomics wrote:
This is similar to another current post about RMySQL crashing R, except on
the other post it crashed on connection to the database. I can successfully
connect, and even can do dbListTables(). But, if I send a query or anything
to actually see the data, R crashes to desktop.
I have tried this on two computers, one Vista, one XP. Both crashed. I am
running 2.8.1, and am using the correct version of DBI and RMySQL. They are
both loaded with the library() function beforehand. Versions of MySQL that
it was tried are 5.1 and 6.0a.
I have searched on the internet and haven't found any answers, and would be
grateful for any help,
I'd recommend using RODBC instead.
The disadvantage is that you'll be at the mercy of whoever wrote the
ODBC driver, but I believe I've had good experience with the MySQL one.
Duncan Murdoch
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
