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