Re: [R] RODBC, postgresql on Linux

From: Prof Brian Ripley <>
Date: Fri, 11 Jan 2008 08:38:04 +0000 (GMT)

On Thu, 10 Jan 2008, Poizot Emmanuel wrote:

> Dear all,
> I facing pbs using RODBC library.
> I'm working on a Linux (Ubuntu Gutsy) os, with R version 2.5.1.
> I've got Postgresql 8.2.5 installed with the odbc-postgresql package.
> I try to connect in a R session to a postgresql database using:
> odbcConnect(dsn="thedatabasename",uid="theuser",pwf="thepasswd",case="postgresql")
> I get a message error, connection failes in odbcDriverConnect(...)
> I don't know where I'm wrong, as I verified the postgresql deamon is ok and
> that the database I want to access is defined.

You should get a quite extensive error message giving the real error. But note that a DSN is not "thedatabasename", and I suspect you have not set up the DSN correctly: see RODBC's README.

First get your DSN working in isql: RODBC is not an ODBC tutorial (but its documentation does reference such).

Brian D. Ripley,        
Professor of Applied Statistics,
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________ mailing list
PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.
Received on Fri 11 Jan 2008 - 08:45:51 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 11 Jan 2008 - 09:30:06 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive