R help - Jan 2009 - RMySQL crashes R

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,

Nathan Forczyk
Auburn University
-- 
View this message in context:
http://www.nabble.com/RMySQL-crashes-R-tp21419908p21419908.html
Sent from the R help mailing list archive at Nabble.com.

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