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

[Oliver Bandel]

Hello,

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.


Ciao,
   Oliver