Geek Answers Handbook

Error trying to connect R to PostgreSQL using RODBC

I am trying to connect to R using RODBC. However, when I run

ch <- odbcConnect("rails_dev", uid="skline", pwd="d0gsleep")

I get this error:

In odbcDriverConnect("DSN=rails_dev;UID=skline;PWD=d0gsleep") :
  [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded

Any thoughts? I am new to this and do not understand what to do next ... thank you very much! "

Note. I am using mac osx

+5
source share
2 answers

EDIT: The answer below is deprecated since some of the packages indicated are no longer available on CRAN. I leave it here for reference.

More information can be found in the following question:

How to connect R with PostgreSQL to OSX 10.10.2?

PostgreSQL Mac RpgSQL. , PostgreSQL JDBC. . PostgreSQL, Stack Builder (. ). Stack Builder ( postgreSQL) , . " " postgresql JDBC.

rdbi, , CRAN, afaik .

ODBC, PostgreSQL, ODBC . . , - Openlinksw "" pgFoundry. , ODBC Stack Builder, JDBC-: postgresql ODBC.

OSX odbc. , Eelke, Apple, . .. PostgreSQL ODBC. , . FAQ iODBC ODBC Mac.

: R , DSN , odbcDataSources() RODBC. Postgresql , , .

+2

, , Actual Technologies Mac OSX (MySQL, PostgreSQL), Oracle, Microsoft Access .., 35 . ODBC- , (System DSN) , , .

0

More articles:


All Articles