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:sdavis2@mail.nih.gov]
  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]]


