[R-sig-DB] RMySQL for windows

[Peter Sørensen (HAG)]

Dear List,
 
Uptill now I have been using RMySQL on Windows and installed it by downloading the precompiled (binary) version of RMySQL for windows from http://stat.bell-labs.com/RS-DBI/download/. It works great.
I have now upgraded R to 2.4.0 and would like to install RMySQL again, but the binary version (RMySQL 0.5-7 <https://djfpost.agrsci.dk/exchange/pso/Kladder/RE:%20%5BR-sig-DB%5D%20RSQLite%20and%20SQLite%203.3.x.EML/RMySQL/RMySQL_0.5-7.zip>  ) downloaded from the above website does not work with R2.4.0 ( but it did work with R version 2.4.0 Under development (unstable) (2006-07-25 r38698)). 
 
I get the following error message with R2.4.0:
> library(RMySQL)
> drv <- dbDriver("MySQL", max.con = 25)
> con <- dbConnect(drv, host="localhost",user="root", password="pomp06", dbname="ggdb2r")
Error in function (classes, fdef, mtable)  : 
        unable to find an inherited method for function "dbConnect", for signature "MySQLDriver"
>
 
I have looked for a windows binary of RMySQL for R2.4.0 at the R/Bioconductor websites, but could not find any. 
Is there a windows binary avaliable somewhere?
 
I then tried to install the package from source ( using the commands pasted below) on Windows, but run into the following problem: 
 
" installation of package 'RMySQL' had non-zero exit status in: install.packages("RMySQL", type = "source") " 

I have followed the instructions "6 Add-on packages" from the R-help, but this is the first time I tried to install a package from source so maybe I am doing something wrong. I will continue to try to solve problem, but if someone would have seen something similar and perhaps give me some directions on how to solve the problem I would of course appreciate that.
 
I hope that my questions are clear and that this is the right place to send these questions.
 
Thanks 
 
Peter 
 
> install.packages("RMySQL", type="source")
trying URL 'http://www.biometrics.mtu.edu/CRAN/src/contrib/RMySQL_0.5-9.tar.gz'
Content type 'application/x-gzip' length 142529 bytes
opened URL
downloaded 139Kb

The downloaded packages are in
        C:\Documents and Settings\sor\Local Settings\Temp\RtmpEVzIqb\downloaded_packages
updating HTML package descriptions
Warning message:
installation of package 'RMySQL' had non-zero exit status in: install.packages("RMySQL", type = "source") 
>

 
 
> sessionInfo()
R version 2.4.0 (2006-10-03) 
i386-pc-mingw32 
locale:
LC_COLLATE=English_United States.1252;LC_CTYPE=English_United States.1252;LC_MONETARY=English_United States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252
attached base packages:
[1] "methods"   "stats"     "graphics"  "grDevices" "utils"     "datasets"  "base"     
other attached packages:
     DBI 
"0.1-10"