[R-sig-DB] Connecting to Postgresql with R under Debian Woody.

[Geotronix]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

* giovedì 30 ottobre 2003, alle 12:54, Dirk Eddelbuettel scrive:
> 
> That looks like a very random mix of a 1.8.1 prerelease (from unstable), 
> and the by now old 1.5.1 from stable. This is almost surely a bad idea.

Oopps, :-) I didn't notice that. My system is a 70% stable & 30%
unstable so sometimes I miss these mixes.
> 
> There are recompiled 1.8.0 packages for Debian stable on CRAN. Why not use
> those?

I forgot to look at www.apt-get.org ;-) so thanks for reminding me.

> 
> Well, you need to install the corresponding CRAN packages.  Dbi and friends
> are not available as Debian packages.
> 
> To return this to 'how do I connect to Pg under Debian 3.0':
> 
> -- install odbc-postgresql and its Depends to give you ODBC on Debian
> -- set up DSN entries (not trivial, and I wish it was documented better)
>    I thing there is some documentation in r-cran-rodbc
> -- use RODBC to connect to Pg via ODBC.
>

Mmm, I remember I had a lot of problems setting up ODBC when I wanted to
get it to work with openoffice.org .......... hope it'll be easier now.

Sorry, but how do I get to this r-cran-rodbc. I tried a search on the
r-project serch engine page but had no luck. Is it a directory under the
CRAN tree? or what? I tried to google it but was even less luckier. It
doesn't seem to be a deb package as apt-cache search returned nothing.

Bye

BTW. Updated docs on the RODBC stuff? Is the "R Data Import/Export" pdf
file for 1.8.0 the most updated on this?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/oWoaIRaQQEznKxURAoNfAJsHeRYYHQuaZTXTUHU4l1JZ6cfsXgCgzzbn
T+FwqBRS4HW7FEajIBYp3Y4=
=QB3A
-----END PGP SIGNATURE-----