[R] RODBC: how to set the data-source?

Oliver Bandel oliver at first.in-berlin.de
Fri Aug 28 17:22:08 CEST 2009


I want to try to connect R to PostgreSQL.

I have found that there are three ways:
DBI or RODBC or RPostgreSQL.

I tried around with DBI and RODBC but didn't get it running.

In both cases I'm not clear about how to set the driver/data source.

I get this error:

x  > channel <- odbcConnect("rtest", uid="oliver")
x  Warning messages:
x  1: In odbcDriverConnect(st, ...) :
x    [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data
x  source name not found, and no default driver specified
x  2: In odbcDriverConnect(st, ...) : ODBC connection failed
x  > 

So I somehow have to set the Driver.
But how?
I didn't find it out.


More information about the R-help mailing list