Hello,

This forum has been very helpful to me in the past, and I've run out of ideas on how to solve my problem.

I had been using R and MySQL (and Perl) together for quite some time successfully on my Windows XP machine. However, I recently had some problems with MySQL (the ibdata file had become 35GB on my hard drive, turns out it's a known bug with InnoDB), and ultimately the way I fixed my problem with MySQL was to upgrade it.  It's working fine now, I can use MySQL however I'd like.  I'm sticking to MyISAM tables for now, though.

However, I had set up my system so I did a linear regression in R. Originally, this was done in R 2.5.0, I would load in the tables from MySQL to R and then conduct the regression in R.  However, after solving my MySQL problem, I ran into a strange error in R (and DBI/RMySQL).  R connected to the database just fine, and I could even show the tables in the database and load two of them into R.  However, the tables I loaded successfully were only a single column.  Every time I tried to load in a recordset that was multiple columns, I got a relatively nondescript Windows error("R for Windows terminal front-end has encountered a problem and needs to close.  We are sorry for the inconvenience.").  To verify that it wasn't a memory issue,  I even tried "rs <- dbSendQuery(con, "select 'a', 'b'")".  This statement causes the error as well.

I tried upgrading the packages, and upgrading R from 2.5.0 to 2.8.1.  However, I still get the same errors.  Has anyone run into this problem before?  Any suggestions on how to solve it?

Thanks in advance,
Aaron


      
	[[alternative HTML version deleted]]


