[R] postgres

[Joshua Gramlich]

Right, but you see, I'm not trying to make a connection in R yet, I'm
trying to get the right tools installed.  I have found zero coherent
documentation for any of this stuff.  Yes, there's the import/export
guide, and that's helpful and all but it doesn't tell me what I need to
do with these files:

DBI.RPgSQL_0.1-2.tar.gz
Rdbi_0.1-2.tar.gz
Rdbi.PgSQL_0.1-2.tar.gz

None of these files contains any documentation either.

...now, when I go to 

http://rpgsql.sourceforge.net/

There's no documentation there either.  In fact, there's only a message
saying that this project has been deprecated in favor of Rdbi.  If you
click on the download link, you get an error from sourceforge, so you
cannot even get the code through the sourceforge website.  If you go to
the Rdbi page, there isn't anything there either...and on the
sourceforge page the download is for version 0.1.2.

...and that just covers the postgres specific stuff.


As to how RODBC works, I don't know, because I haven't found any
documentation specifically about that either.  Again, there's the
import/export guide, but that's only about how to use it, not how to get
one's system set up to use it.   All I've figured out to do is run
"install.packages("RODBC")"...which begins the installation process, but
because the driver manager apparently isn't set up correctly, it tells
me I must install a driver manager....or "no ODBC driver manager found".

I have unixODBC installed...

Ugh.  I'm giving up on this for today.  I just found out that there is
no odbc rpm for postgres 7.3.1, so i'm gonna have to go back to 7.2.4 to
get that functionality in rpm format...which means blowing out my
database...which means tomorrow.


Thanks for all the help so far folks.


Josh
Chicago







On Tue, 2003-02-11 at 16:11, Jason W. Martinez wrote:
> 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
>