Hi, I'm thankful for any help on installing RMySQL on Windows XP for R 1.9.1 The thread http://tolstoy.newcastle.edu.au/R/help/04/01/1021.html already tried to discuss the matter. It concludes that Windows Sources for Packages are alike the Linux ones. So I extracted the files from the RMySQL_*.tar.gz from http://stat.bell-labs.com/RS-DBI/download/index.html and stuffed them into a zip-file which was willingly taken by the install routine of my RGui. It said the well known "updating HTML package descriptions" but when using library(RMySQL) the error "Error in testRversion(descfields) : This package has not been installed properly. See the Note in ?library". Obviously the note wasn't very helpful and so I ask you for any help. Regards Robert
Hi, I cannot help you install RMySQL on Windows, but most likely RMySQL contains non-R code too, such as C code, that requires compilation and then your gunzip-untar-rezip approach will not work. For your information, you can use the RODBC package instead. I recently downloaded and installed a MySQL server on my Windows XP *Pro* machine. Then I use the RODBC package (on CRAN and installs directly on Windows) to connect to it. In order for this to work you have to have an ODBC service running on your machine. You will find one for most Windows versions called MyODBC on the mysql.com download pages (links at the right margin). When it works you will be connected to you db from R by library(RODBC) channel <- odbcConnect("MyDatabase", uid="root") # or some other username df <- sqlQuery("select * from myTable") See also ?RODBC. I just did the above two days ago from scratch and it was pretty easy. I won't time to help you more now since I'm writing up my thesis... Cheers Henrik Bengtsson> -----Original Message----- > From: r-help-bounces at stat.math.ethz.ch > [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Robert Wania > Sent: Monday, August 09, 2004 11:34 AM > To: r-help at stat.math.ethz.ch > Subject: [R] Installing RMySQL on Windows XP for R 1.9.1 > > > Hi, > > I'm thankful for any help on installing RMySQL on Windows XP > for R 1.9.1 > > The thread http://tolstoy.newcastle.edu.au/R/help/04/01/1021.html > already tried to discuss the matter. It concludes that > Windows Sources for Packages are alike the Linux ones. > > So I extracted the files from the RMySQL_*.tar.gz from > http://stat.bell-labs.com/RS-DBI/download/index.html > and stuffed them into a zip-file which was willingly taken by > the install routine of my RGui. It said the well known > "updating HTML package descriptions" but when using > library(RMySQL) the error "Error in testRversion(descfields) > : This package has not been installed properly. See the Note > in ?library". Obviously the note wasn't very helpful and so I > ask you for any help. > > Regards > Robert > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html > >
The code snippet was incorrect; here the correct one (I hope) library(RODBC) channel <- odbcConnect("MyDatabase", uid="root") # or some other username df <- sqlQuery(channel, "select * from myTable") /Henrik> -----Original Message----- > From: Henrik Bengtsson [mailto:hb at maths.lth.se] > Sent: Monday, August 09, 2004 11:59 AM > To: 'Robert Wania'; 'r-help at stat.math.ethz.ch' > Subject: RE: [R] Installing RMySQL on Windows XP for R 1.9.1 > > > Hi, I cannot help you install RMySQL on Windows, but most > likely RMySQL contains non-R code too, such as C code, that > requires compilation and then your gunzip-untar-rezip > approach will not work. > > For your information, you can use the RODBC package instead. > I recently downloaded and installed a MySQL server on my > Windows XP *Pro* machine. Then I use the RODBC package (on > CRAN and installs directly on Windows) to connect to it. In > order for this to work you have to have an ODBC service > running on your machine. You will find one for most Windows > versions called MyODBC on the mysql.com download pages (links > at the right margin). When it works you will be connected to > you db from R by > > library(RODBC) > channel <- odbcConnect("MyDatabase", uid="root") # or some > other username > df <- sqlQuery("select * from myTable") > > See also ?RODBC. I just did the above two days ago from > scratch and it was pretty easy. I won't time to help you more > now since I'm writing up my thesis... > > Cheers > > Henrik Bengtsson > > > > -----Original Message----- > > From: r-help-bounces at stat.math.ethz.ch > > [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Robert Wania > > Sent: Monday, August 09, 2004 11:34 AM > > To: r-help at stat.math.ethz.ch > > Subject: [R] Installing RMySQL on Windows XP for R 1.9.1 > > > > > > Hi, > > > > I'm thankful for any help on installing RMySQL on Windows XP > > for R 1.9.1 > > > > The thread http://tolstoy.newcastle.edu.au/R/help/04/01/1021.html > > already tried to discuss the matter. It concludes that > > Windows Sources for Packages are alike the Linux ones. > > > > So I extracted the files from the RMySQL_*.tar.gz from > > http://stat.bell-labs.com/RS-DBI/download/index.html > > and stuffed them into a zip-file which was willingly taken by > > the install routine of my RGui. It said the well known > > "updating HTML package descriptions" but when using > > library(RMySQL) the error "Error in testRversion(descfields) > > : This package has not been installed properly. See the Note > > in ?library". Obviously the note wasn't very helpful and so I > > ask you for any help. > > > > Regards > > Robert > > > > ______________________________________________ > > R-help at stat.math.ethz.ch mailing list > > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide! > > http://www.R-project.org/posting-guide.html > > > > >