using postgresql with R/RODBC

Hi, Please excuse these questions if they're obvious. I'm new to R.

I need to access a Postgres db from R.  I'm currently trying RODBC as
I spend part of my time on Windows and rdbi.pgsql seems not to support
windows at this time.

I unzipped the RODBC win binary download into my library directory and
tried to load it using

library(RODBC)

I get the following error:

Error in dyn.load(x, as.logical(local), as.logical(now)) :   unable to
load shared library
"C:/PROGRA~1/R/rw2001/library/RODBC/libs/RODBC.dll":
  LoadLibrary failure:  The specified procedure could not be found.
In addition: Warning message:  package 'RODBC' was built under R version 2.1.0 
So why don't you use the binary package from CRAN that has been compiled 
for you under R-2.0.1?

Uwe Ligges
Error: .onLoad failed in loadNamespace for 'RODBC'
Error in library(RODBC) : package/namespace load failed for 'RODBC'

The path correctly points to the dll. Can anyone tell me what I'm doing wrong? 

thanks.

______________________________________________
R-help at 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

using postgresql with R/RODBC

Thread (4 messages)