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 ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.