RPgSQL etc seem now to be unsupported.
As for ODBC, there is some information in the README *but* setting up ODBC
is not an R question. Once you have a working connection (tested by say
isql -v foo), then odbcConnect("foo") will work too. There is lots of
documentation on the unixODBC site. Where I would be critical is of the
Postrgres ODBC documentation: there are several drivers, no documentation
and most of them are broken. The one place you will find how to do it is
in the RODBC README. So I do resent your comments.
>From that README:
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
> > > > > [EMAIL PROTECTED] http://mug.sys.virginia.edu/~drf5n/
> > > >
> > > > -----------------------------------------------------
> > > > John Fox
> > > > Department of Sociology
> > > > McMaster University
> > > > Hamilton, Ontario, Canada L8S 4M4
> > > > email: [EMAIL PROTECTED]
> > > > phone: 905-525-9140x23604
> > > > web: www.socsci.mcmaster.ca/jfox
> > > > -----------------------------------------------------
> > > >
> > > > ______________________________________________
> > > > [EMAIL PROTECTED] mailing list
> > > > http://www.stat.math.ethz.ch/mailman/listinfo/r-help
> > >
> > > ______________________________________________
> > > [EMAIL PROTECTED] mailing list
> > > http://www.stat.math.ethz.ch/mailman/listinfo/r-help
> >
> > --
> > Jason W. Martinez, Graduate student
> > Department of Sociology
> > University of California, Riverside
> >
>
> ______________________________________________
> [EMAIL PROTECTED] mailing list
> http://www.stat.math.ethz.ch/mailman/listinfo/r-help
>
--
Brian D. Ripley, [EMAIL PROTECTED]
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
______________________________________________
[EMAIL PROTECTED] mailing list
http://www.stat.math.ethz.ch/mailman/listinfo/r-help
