[R] RODBC: how to set the data-source?
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
So I somehow have to set the Driver.
I didn't find it out.
More information about the R-help