R help - Oct 2004 - Problem with RMySQL-0.5-3.zip/R 2.0.0 on Windows XP

I have been installing and using the RMySQL package, version 0.5-3 with R
versions 1.9.0 and 1.9.1 on Windows XP without  any problem. I installed the
package using the .zip binary package available at
http://stat.bell-labs.com/RS-DBI/download/index.html.

However,  I ran into a problem using this package with the latest version 2.0.0
of R. The installation went ok, but loading the library using

library(RMySQL)

caused the following error:

Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed
< 2.0.0?

Any comment/suggestion/advice on how to resolve this issue is greatly
appreciated.

Vu Ha, PhD
Information and Decision Technologies
Honeywell International
3660 Technology Dr. 
Minneapolis, MN 55418 
612-951-7114

On Mon, 11 Oct 2004 vha at comcast.net wrote:
> I have been installing and using the RMySQL package, version 0.5-3 with
> R versions 1.9.0 and 1.9.1 on Windows XP without any problem. I
> installed the package using the .zip binary package available at
> http://stat.bell-labs.com/RS-DBI/download/index.html.
> 
> However, I ran into a problem using this package with the latest version
> 2.0.0 of R. The installation went ok, but loading the library using
> 
> library(RMySQL)
> 
> caused the following error:
> 
> Error in library(RMySQL) : 'RMySQL' is not a valid package --
installed < 2.0.0?
> 
> Any comment/suggestion/advice on how to resolve this issue is greatly
appreciated.
You need to build it from the sources under R 2.0.0 unless/until someone 
provides a binary for 2.0.0.


-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

Thank you very much, David. I installed the compiled RMySQL zip package and it
works fine now.

Witold Eryk Wolski also suggested the following way to get around having to
recompile.

<quote>
In the package directory is directory called meta. There are some *.rds 
files generated I during the build, preparing the package for lazy eval. 
(see last Rnew BDRipleys article)
copy package.rds nad Rd.rds from any of the packages build for R2.0.0 to 
the meta directory. This should solve your problem.
</quote>

This however did not work for me. I can load the library ok, but when I make a
call to dbDriver, I got a complain about dbiDriver.

Vu~

> Dear Vu Ha,
> 
> I just re-complied the RMySQL package on Windows for R 2.0.0.  Please
> see attached file zip (you need to rename it to RMySQL_0.5-5.zip).
> Could you please tell me if that works for you?
> 
> Regards,
> 
> --
> David
> 
> vha at comcast.net wrote:
> > I have been installing and using the RMySQL package, version 0.5-3
with R
> versions 1.9.0 and 1.9.1 on Windows XP without  any problem. I installed
the
> package using the .zip binary package available at 
> http://stat.bell-labs.com/RS-DBI/download/index.html.
> > 
> > However,  I ran into a problem using this package with the latest
version
> 2.0.0 of R. The installation went ok, but loading the library using
> > 
> > library(RMySQL)
> > 
> > caused the following error:
> > 
> > Error in library(RMySQL) : 'RMySQL' is not a valid package --
installed <
> 2.0.0?
> > 
> > Any comment/suggestion/advice on how to resolve this issue is greatly 
> appreciated. 
> > 
> > Vu Ha, PhD
> > Information and Decision Technologies
> > Honeywell International
> > 3660 Technology Dr. 
> > Minneapolis, MN 55418 
> > 612-951-7114
> > 
> > ______________________________________________
> > R-help at stat.math.ethz.ch mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html