From murdoch at stats.uwo.ca  Mon Oct 20 18:42:15 2008
From: murdoch at stats.uwo.ca (Duncan Murdoch)
Date: Mon, 20 Oct 2008 12:42:15 -0400
Subject: [Rd] R application dies of with windows (PR#13179)
In-Reply-To: <20081020122003.C6219282C76E@mail.pubhealth.ku.dk>
References: <20081020122003.C6219282C76E@mail.pubhealth.ku.dk>
Message-ID: <48FCB4E7.6030907@stats.uwo.ca>

On 10/20/2008 8:20 AM, sheetal.raut at gmail.com wrote:
> Full_Name: sheetal ganpat raut
> Version: R 2.7.2
> OS: windows XP
> Submission from: (NULL) (59.183.4.201)
> 
> 
> Hi,
> I m trying to establish connectivity between R 2.7.2 & MySQL server 5.1. I have
> succeded in retriving single data column(field) from database of  MySQL. But I m
> unable to retrive whole table. Whenever I fire dbReadTable or dbGetQuery or
> dbSendQuery method to retrive whole table R throws error saying R for windows
> front end application has encountered a problem and need to close the
> application.
> 
> I m using RMysql-0.6 and DBI 0.2-4.

This looks like a bug with one of those contributed packages, not with 
R.  Please send your report to the maintainer.

You might find better luck using RODBC.

Duncan Murdoch



[Rd] R application dies of with windows (PR#13179)
Duncan Murdoch