[R] postgres

Jason W. Martinez jmartinez at uia.net
Tue Feb 11 23:05:13 CET 2003


Josh,

It sounds like part of your problem is that you're not reading all of the 
documentation. The first step is to _understand_ what an ODBC Manager is AND 
what it is supposed to be doing.

You have to configure your manager (among other things) before you can even 
begin to make a connection from R with (RODBC).

Don't get discouraged. ODBC is beautiful thing! Further, I make connections 
with RODBC to postgresql databases all the time. It is possible, just be 
patient and read the docs.

Jason

On Tuesday 11 February 2003 01:48 pm, Joshua Gramlich wrote:
> I'm actually looking at that exact page in the import/export manual
> right now.  I'm trying to install RODBC via CRAN, but I get this:
>
> ....blahblahblah...
> checking for library containing SQLTables... no
> configure: error: "no ODBC driver manager found"
> ERROR: configuration failed for package 'RODBC'
>
> Delete downloaded files (y/N)? y
>
> Warning message:
> Installation of package RODBC had non-zero exit status in:
> install.packages("RODBC")
>
>
>
> I tried installing unixODBC, but that didn't seem to solve the problem.
>
> Thoughts?
>
>
>
> Josh
> Chicago
>
> On Tue, 2003-02-11 at 15:31, John Fox wrote:
> > Dear David and Joshua,
> >
> > One can also access PostgreSQL via the RODBC package. There's more
> > information in section 4 of the R Data Import/Export manual, which is
> > part of the R distribution and is also available on CRAN.
> >
> > John
> >
> > At 04:08 PM 2/11/2003 -0500, David Forrest wrote:
> > >On 11 Feb 2003, Joshua Gramlich wrote:
> > > > Is anyone using R with postgres?  I'd like to do so, but cannot seem
> > > > to find any reasonable explanation of how to do so.
> > > >
> > > >
> > > > Joshua Gramlich
> > > > Chicago, IL
> > >
> > >library(RPgSQL)  # It isn't in an obvious place:
> > >                  # http://lib.stat.cmu.edu/R/CRAN/src/contrib/Devel
> > >db.connect()
> > >db.ls()
> > >
> > >Dave,
> > >--
> > >  Dave Forrest    (434)924-3954w(111B) (804)642-0662h (804)695-2026p
> > >  drf5n at virginia.edu             http://mug.sys.virginia.edu/~drf5n/
> >
> > -----------------------------------------------------
> > John Fox
> > Department of Sociology
> > McMaster University
> > Hamilton, Ontario, Canada L8S 4M4
> > email: jfox at mcmaster.ca
> > phone: 905-525-9140x23604
> > web: www.socsci.mcmaster.ca/jfox
> > -----------------------------------------------------
> >
> > ______________________________________________
> > R-help at stat.math.ethz.ch mailing list
> > http://www.stat.math.ethz.ch/mailman/listinfo/r-help
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> http://www.stat.math.ethz.ch/mailman/listinfo/r-help

-- 
Jason W. Martinez, Graduate student
Department of Sociology
University of California, Riverside




More information about the R-help mailing list