Re: [R] RODBC, postgresql on Linux

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
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,                  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

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
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 https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive