[R-sig-DB] RMySQL package on windows 2k

[Gabor Grothendieck]

On 7/23/07, Prof Brian Ripley <ripley using stats.ox.ac.uk> wrote:
> On Mon, 23 Jul 2007, along zeng wrote:
> >     I want to visit MySQL databse in R using pacakge RMySQL on
> > plateform Windows 2k,but I visited some CRAN,such as Berkeley,UCLA
> > ,UCDavis in US,crycit of Argentina ,unfortunately,only package of
> > RMySQL on MacOS could find! Could somebody tell me where and how can I
> > get it?
> >  Thanks a lot.
> >   along
> >
> Please read the @ReadMe there!  It says
>
> The packages
>   gsl, ncdf, rgdal, RMySQL, RNetCDF, udunits, and xgobi
> do not build out of the box. Nevertheless these are available at
>   http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.5/
> kindly provided by Professor Brian D. Ripley.
>
> which is the CRANextras repository which is selected by default, so
> install.packages("RMySQL") should work.  But note that
> http://www.stats.ox.ac.uk/pub/RWin/ReadMe says
>
>   The build of RMySQL_0.6-0 is known to work with MySQL 5.0.21, and known
>   not to work with 5.0.41.
>
> whereas RODBC works with 5.0.41.

I have been using the RMySQL 0.6-0 build by Paulino Perez Rodriguez (not
the one on CRAN Extras) with MySQL 5.4.1 and have not noticed any
problems to date.

What is the problem that you encountered?