R Source Packages

   R CMD INSTALL pkg-name_X.Y-Z.tar.gz

• DBI 0.1-10 (required by the three packages below). See the NEWS file.
• ROracle 0.5-7 See the NEWS or the INSTALL file.
• RMySQL 0.5-7 See the NEWS or the INSTALL file.
• RSQLite 0.4-1 See the NEWS or the INSTALL file.

R Windows Binary Packages

• DBI

  This package is required by all other packages here. It contains R code only.

  • DBI built with R 2.2.1
  • DBI built with R 2.1.1

• ROracle Windows binaries
  • ROracle 0.5-7 built with R 2.2.1 and Oracle 9.2

    This binary package was built using the Microsoft Visual C++ compiler. You will need the Oracle runtime client libraries in order to use it. Make sure your PATH includes the $ORACLE_HOME/bin directory.

• RMySQL Windows binaries
  • RMySQL 0.5-7 built with R 2.2.1 and MySQL 5.0.18
  • RMySQL 0.5-6 built with R 2.1.1 and MySQL 4.1.12a
  • RMySQL 0.5-5 built with R 2.0.0 and MySQL 4.0.18

  These binaries include copies of MySQL runtime client libraries from MySQL in RMySQL's libs directory. Thus you do not need to install MySQL on your Windows system in order to use RMySQL. However, if you already have MySQL installed, make sure that R picks the libraries in RMySQL's libs directory (perhaps by copying libMySQL.dll from RMySQL/libs to $R_HOME/bin, or including RMySQL/libs early in your PATH), otherwise conflicts will most likely cause core dumps.

  For details on how to compile RMySQL on windows, see the files README.windows, configure.win and src/Makevars.win in the latest source package.

• SQLite

  These binaries include the SQLite database engine and are thus self contained (of course, the DBI package is still required).

  • RSQLite 0.4-1 built with R 2.1.1 and SQLite 3.2.8.
  • RSQLite 0.3-3 includes SQLite 2.8.6.

S-Plus Source Packages

• S-MySQL (see installation instructions here).
• S-Oracle

Two issues associated with R 1.8.0

A minor problem in R 1.8.0

> m <- dbDriver("MySQL")
> Error in dbDriver("MySQL") : couldn't find function ".valueClassTest"

The following are some workarounds:

• append the line

  export(.valueClassTest)
  

  to the file $R_HOME/src/library/methods/NAMESPACE where $R_HOME refers to the directory where you have R 1.8.0 installed.
• Or update to a later R version (the patched version of 1.8.0 is known to work);
• you can also use R 1.7.1.