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: [email protected] 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: [email protected] 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]] > > ______________________________________________ > [email protected] 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]] ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
