Re: [R] looking for the RMySQL package for R 2.12.0 under XP
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 database through ODBC window. With the following command, ch<-odbcDriverConnect(connection="SERVER=localhost;DRIVER=MySQL ODBC 5.1 Driver;DATABASE=my_db;UID=my_user;PWD=my_pwd;case=tolower") the connection runs nicely. Thanks again for the link. Happy New Year to all the R-users, Ptit Bleu. -- View this message in context: http://r.789695.n4.nabble.com/looking-for-the-RMySQL-package-for-R-2-12-0-under-XP-tp3057537p3175513.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] looking for the RMySQL package for R 2.12.0 under XP
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 used rtool : - are the administration rights are requested (to install or/and to use it) ? - after the installation, install.packages('RMySQL',type='source') is the only things to do or more skills in computer are needed ? I will have a look at the R-sig-DB list if I can't do it alone. Again thanks for your help and advices. Ptit Bleu -- View this message in context: http://r.789695.n4.nabble.com/looking-for-the-RMySQL-package-for-R-2-12-0-under-XP-tp3057537p3058891.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] looking for the RMySQL package for R 2.12.0 under XP
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 guy to add the MySQL/ODBC connector. The instructions may not be quite up to date but hopefully you can find your way through. Our students generally manage to set it all up on their own computers. David Scott On Wed, Nov 24, 2010 at 1:48 PM, PtitBleu 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 to install on his computer the same packages I use (but I have R 2.11) and especially RMySQL. Problem : there is no more RMySQL package in the list pf the packages. I've tried to install my version but it is not compatible. I saw on a website a possible solution using rtools but it was very unclear to me (I'm only an end-user and French ...) and with no admin rights, I think I won't be able to follow the proposed procedure. Do you know where I can find a zip file of the RMySQL package for R 2.12 ? Thanks in advance, Ptit Bleu. PS : everybody around me is using matlab. If I say that I have a problem to connect R to MySQL, I will have to move to matlab. So please, help !!! :-) -- View this message in context: http://r.789695.n4.nabble.com/looking-for-the-RMySQL-package-for-R-2-12-0-under-XP-tp3057537p3057537.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- _ David Scott Department of Statistics The University of Auckland, PB 92019 Auckland 1142,NEW ZEALAND Phone: +64 9 923 5055, or +64 9 373 7599 ext 85055 Email: d.sc...@auckland.ac.nz, Fax: +64 9 373 7018 Director of Consulting, Department of Statistics __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] looking for the RMySQL package for R 2.12.0 under XP
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 MySQL as well as the version of R. I just upgraded to R 2.12.0, and now I need to repeat that process myself. If this does not answer your questions, I suggest you subscribe to "R-sig-DB" and post your question there. They don't have much traffic and may be more responsive to questions like this. Hope this helps. Spencer On 11/24/2010 7:48 AM, PtitBleu 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 to install on his computer the same packages I use (but I have R 2.11) and especially RMySQL. Problem : there is no more RMySQL package in the list pf the packages. I've tried to install my version but it is not compatible. I saw on a website a possible solution using rtools but it was very unclear to me (I'm only an end-user and French ...) and with no admin rights, I think I won't be able to follow the proposed procedure. Do you know where I can find a zip file of the RMySQL package for R 2.12 ? Thanks in advance, Ptit Bleu. PS : everybody around me is using matlab. If I say that I have a problem to connect R to MySQL, I will have to move to matlab. So please, help !!! :-) __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] looking for the RMySQL package for R 2.12.0 under XP
You need compile it from source code. On Wed, Nov 24, 2010 at 1:48 PM, PtitBleu 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 to install on his computer the same packages I use (but I have R > 2.11) and especially RMySQL. > > Problem : there is no more RMySQL package in the list pf the packages. > I've tried to install my version but it is not compatible. > > I saw on a website a possible solution using rtools but it was very unclear > to me (I'm only an end-user and French ...) and with no admin rights, I > think I won't be able to follow the proposed procedure. > > Do you know where I can find a zip file of the RMySQL package for R 2.12 ? > > Thanks in advance, > Ptit Bleu. > > PS : everybody around me is using matlab. If I say that I have a problem to > connect R to MySQL, I will have to move to matlab. So please, help !!! :-) > > > -- > View this message in context: > http://r.789695.n4.nabble.com/looking-for-the-RMySQL-package-for-R-2-12-0-under-XP-tp3057537p3057537.html > Sent from the R help mailing list archive at Nabble.com. > > __ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > -- Henrique Dallazuanna Curitiba-Paraná-Brasil 25° 25' 40" S 49° 16' 22" O [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.