R help - Jan 2008 - RODBC, postgresql on Linux

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.

-- 

------------------------------------------------
Emmanuel Poizot
Cnam/Intechmer
B.P. 324
50103 Cherbourg Cedex

Phone (Direct) : (00 33)(0)233887342
Fax : (00 33)(0)233887339
------------------------------------------------

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