RE: [R] functions not found after installing DBI/RDBI packages
hi - thanks for the response, I've changed to using the ODBC driver and MySQL as i didn't want to be tied to using linux, and it seems there is no easily installable version of the postgres driver for windows. cheers, colin -Original Message- From: Sean Davis [mailto:[EMAIL PROTECTED] Sent: Fri 21/01/2005 11:45 To: Combe, Colin Cc: r-help@stat.math.ethz.ch Subject: Re: [R] functions not found after installing DBI/RDBI packages Colin, Rdbi provides generic methods for working with databases. It requires a driver for a specific database, as well. Therefore, you will need to download and install RdbiPgSQL, also. Sean On Jan 21, 2005, at 4:58 AM, Combe, Colin wrote: Hi, I would like to be able to use R with a connection to a PostgreSQL database. I am using R 2.0.1 on windows XP. I have tried installing both the DBI and rDBI packages (which is better?) but in either case I run into the same problem - when i try to use either the dbDriver or dbConnect functions i'm told the function couldn't be found. Seems like the packages aren't installing properly. I installed DBI from a zip file and rDBI from bioconductor. Any clues as to where i'm going wrong? thanks, colin [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Re: [R] functions not found after installing DBI/RDBI packages
RE: [R] functions not found after installing DBI/RDBI packagesColin, There is an ODBC driver for postgres and there is a binary installer for postgres, just in case you want to use postgres. I think both are available at http://www.postgresql.org. If all you are doing is storing and retrieving data, then mysql will more than suffice. However, it you want to use foreign keys, any stored procedures, etc., you will need postgres. I started out using mysql but have moved to postgres for everything that I can (all my own work), but that is a topic for another list on another day. Sean - Original Message - From: Combe, Colin To: Sean Davis Cc: r-help@stat.math.ethz.ch Sent: Monday, January 24, 2005 6:13 AM Subject: RE: [R] functions not found after installing DBI/RDBI packages hi - thanks for the response, I've changed to using the ODBC driver and MySQL as i didn't want to be tied to using linux, and it seems there is no easily installable version of the postgres driver for windows. cheers, colin -Original Message- From: Sean Davis [mailto:[EMAIL PROTECTED] Sent: Fri 21/01/2005 11:45 To: Combe, Colin Cc: r-help@stat.math.ethz.ch Subject: Re: [R] functions not found after installing DBI/RDBI packages Colin, Rdbi provides generic methods for working with databases. It requires a driver for a specific database, as well. Therefore, you will need to download and install RdbiPgSQL, also. Sean On Jan 21, 2005, at 4:58 AM, Combe, Colin wrote: Hi, I would like to be able to use R with a connection to a PostgreSQL database. I am using R 2.0.1 on windows XP. I have tried installing both the DBI and rDBI packages (which is better?) but in either case I run into the same problem - when i try to use either the dbDriver or dbConnect functions i'm told the function couldn't be found. Seems like the packages aren't installing properly. I installed DBI from a zip file and rDBI from bioconductor. Any clues as to where i'm going wrong? thanks, colin [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Re: [R] functions not found after installing DBI/RDBI packages
Colin, Rdbi provides generic methods for working with databases. It requires a driver for a specific database, as well. Therefore, you will need to download and install RdbiPgSQL, also. Sean On Jan 21, 2005, at 4:58 AM, Combe, Colin wrote: Hi, I would like to be able to use R with a connection to a PostgreSQL database. I am using R 2.0.1 on windows XP. I have tried installing both the DBI and rDBI packages (which is better?) but in either case I run into the same problem - when i try to use either the dbDriver or dbConnect functions i'm told the function couldn't be found. Seems like the packages aren't installing properly. I installed DBI from a zip file and rDBI from bioconductor. Any clues as to where i'm going wrong? thanks, colin [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
