One quirk to be watched is the use of connections to the DBMS via the
Unix sockets vs ports. The PostgreSQL driver bundled with unixODBC
will use Unix sockets to `localhost', but this driver seems unreliable
(see the ChangeLog). The current driver will only use a TCP/IP port,
and to use that needs postmaster started with the -i flag (which is
not the default) and with tcp/ip enables in the configuration file
(which is the default). The PostgreSQL drivers are seriously
under-documented!
On 11 Feb 2003, Joshua Gramlich wrote:
> 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".
Quote from the README:
The RODBC package is installed in the standard way (R CMD
INSTALL RODBC) and needs the ODBC driver manager library (-lodbc or
-lodbc32 or -liodbc) to be in the library search path (and library run
path).
It is just telling you that you have not done that ....
> 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
> >
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> http://www.stat.math.ethz.ch/mailman/listinfo/r-help
>
--
Brian D. Ripley, ripley at stats.ox.ac.uk
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UK Fax: +44 1865 272595