Re: [R] RODBC Error

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Sun 30 Oct 2005 - 18:18:43 EST

On Sat, 29 Oct 2005, Michael Greene wrote:

>
> Hello,
>
> I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to
> connect to a PostgreSQL server on the local network. I can't tell
> whether my problem is in R, or in ODBC setup.

These are ODBC error reports, so the problem is in ODBC.

> I got drivers from OpenLink, created a dsn and tested it using the
> iODBC application. then I load the RODBC package, use this code and
> get the following error. I tried with both the odbcConnect util and
> the odbcDriverConnect util. I am able to connect to the database
> through other non-odbc based database programs from the Mac, so I
> know it's not a Postgres setting (like no tcp/ip connections or
> something).

No, you don't. I've see quite a few problems which were Postgresql (sic) settings affecting the ODBC driver.

> > library(RODBC)
> > channel <- odbcConnect("nfl",uid="postgres", pwd="xxx")
> Warning messages:
> 1: [RODBC] ERROR: Could not SQLDriverConnect
> 2: ODBC connection failed in: odbcDriverConnect(st, case = case,
> believeNRows = believeNRows)
> >
> > channel2 <- odbcDriverConnect(connection="DSN=nfl, UID=postgres,
> PWD=vladdy79" )
> Warning messages:
> 1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver Manager]
> Data source name not found and no default driver specified. Driver
> could not be loaded
> 2: ODBC connection failed in: odbcDriverConnect(connection =
> "DSN=nfl, UID=postgres, PWD=xxx")

-- 
Brian D. Ripley,                  ripley@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@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Received on Sun Oct 30 18:27:36 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:40:53 EST