Re: [R] looking for the RMySQL package for R 2.12.0 under XP

2011-01-05 Thread PtitBleu
Hello David, As I had no time to try to compile the RMySQL package, I finally followed your advice and moved to RODBC. The decision to modify my scripts was taken after I discovered the function odbcDriverConnect which allow to directly connect to database (like RMySQL) without declaring the

Re: [R] looking for the RMySQL package for R 2.12.0 under XP

2010-11-25 Thread PtitBleu
Thank you for all your answers. I've looked at RODBC but it seems that you have to declare the database with the administration tools before using it . With RMySQL, you can do it directly in the R-script which is very convenient for me as I regularly treat new databases. For those who already

[R] looking for the RMySQL package for R 2.12.0 under XP

2010-11-24 Thread PtitBleu
Hello, I convinced our new Ph student to work with R and I managed to convince the guy in charge of the computer networks to install R 2.12.0 (we haven't the admin rights). I wanted to install on his computer the same packages I use (but I have R 2.11) and especially RMySQL. Problem : there is

Re: [R] looking for the RMySQL package for R 2.12.0 under XP

2010-11-24 Thread Henrique Dallazuanna
You need compile it from source code. On Wed, Nov 24, 2010 at 1:48 PM, PtitBleu ptit_b...@yahoo.fr wrote: Hello, I convinced our new Ph student to work with R and I managed to convince the guy in charge of the computer networks to install R 2.12.0 (we haven't the admin rights). I wanted

Re: [R] looking for the RMySQL package for R 2.12.0 under XP

2010-11-24 Thread Spencer Graves
Hello: That package needs to be compiled from source on the computer you are using. Instructions for doing so can be found at http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL;. I'm not sure of all the issues, but I believe it needs to be configured to the specific version of

Re: [R] looking for the RMySQL package for R 2.12.0 under XP

2010-11-24 Thread David Scott
On 25/11/2010 4:55 a.m., Henrique Dallazuanna wrote: You need compile it from source code. An alternative is to use RODBC. There are instructions on my page here: http://www.stat.auckland.ac.nz/~dscott/779/index.php Look in the MySQL section (obviously). You may need to pester your admin