Hello, I have been using RODBC on Windows with version 1.41 of R successfully, connecting to a mysql database using MyODBC. Now I would like to do so with R under Debian/GNU Linux. I just tried RMySQL (install failed, since mysql libraries were not found), DBI (no MySQL driver available) and I can't find the RODBC package any more on CRAN. Any suggestions? Johannes Ranke P.S.: Thanks for all the great work to all! -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> I have been using RODBC on Windows with version 1.41 of R successfully, > connecting to a mysql database using MyODBC. Now I would like to do so > with R under Debian/GNU Linux. > > I just tried RMySQL (install failed, since mysql libraries were not found),Du must das passende -dev Paket mit den header files installieren. Dirk> DBI (no MySQL driver available) and I can't find the RODBC package > any more on CRAN. > > Any suggestions? > > Johannes Ranke > > P.S.: Thanks for all the great work to all! > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- > r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html > Send "info", "help", or "[un]subscribe" > (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch > _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._ > > >-- According to the latest figures, 43% of all signatures are totally worthless. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Hello! RODBC can be found in the "devel" section. Bye, detlef On 06-Jun-2002 Johannes Ranke wrote:> Hello, > > I have been using RODBC on Windows with version 1.41 of R successfully, > connecting to a mysql database using MyODBC. Now I would like to do so > with R under Debian/GNU Linux. > > I just tried RMySQL (install failed, since mysql libraries were not found), > DBI (no MySQL driver available) and I can't find the RODBC package > any more on CRAN. > > Any suggestions? > > Johannes Ranke > > P.S.: Thanks for all the great work to all! > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-. > - > r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html > Send "info", "help", or "[un]subscribe" > (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch > _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._. > _Detlef Steuer --- http://fawn.unibw-hamburg.de/steuer.html ***** Encrypted mail preferred ***** -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Hello all, thanks for all the help. I would like to summarize: If you want to use the same R scripts for accessing a mysql database from Windows and Debian/GNU Linux, you can either 1. install the RMySQL source package from CRAN under debian, and compile it under Windows as well (this sounds a little hairy to me) 2. install unixodbc, compile myODBC 2.50 from www.mysql.org, and install RODBC from CRAN on debian, and install RODBC and myODBC under Windows. This worked for me. Option 2. also involved installing libmysqlclient10-dev and the source package for mysql under debian. Best regards Johannes Ranke * Johannes Ranke <jranke at uni-bremen.de> [020606 17:34]:> Hello, > > I have been using RODBC on Windows with version 1.41 of R successfully, > connecting to a mysql database using MyODBC. Now I would like to do so > with R under Debian/GNU Linux. > > I just tried RMySQL (install failed, since mysql libraries were not found), > DBI (no MySQL driver available) and I can't find the RODBC package > any more on CRAN. > > Any suggestions? > > Johannes Ranke > > P.S.: Thanks for all the great work to all! > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- > r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html > Send "info", "help", or "[un]subscribe" > (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch > _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._ >-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> 2. install unixodbc, compile myODBC 2.50 from www.mysql.org, > and install RODBC from CRAN on debian, and install RODBC and myODBC under > Windows. This worked for me.Just as an addendum, Debian has packages for both iODBC (libiodbc) and unixodbc so you don't have to compile myODBC yourself. Dirk -- According to the latest figures, 43% of all signatures are totally worthless. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._