Can not Connect to a database on Redshift in R by RODBC package

Asked Apr 19 '16 at 12:39

Active Apr 19 '16 at 12:42

Viewed 399 times

I am trying to connect to A DB on Redshift in r using following syntax (I am using a Mac):

odbcConnect("xxxxaddresss.redshift.amazonaws.com:5439", uid = "xxxx", pwd = "xxxx")

and get the following errors.

Warning messages:

1: In RODBC::odbcDriverConnect("DSN=xxxxaddresss.redshift.amazonaws.com:5439;UID=xxxx;PWD=xxxx") : [RODBC] ERROR: state IM012, code 0, message [unixODBC][Driver Manager]DRIVER keyword syntax error

2: In RODBC::odbcDriverConnect("DSN=xxxxaddresss.redshift.amazonaws.com:5439;UID=xxxx;PWD=xxxx") :

ODBC connection failed

What is the reason of the problem?

edited Apr 19 '16 at 12:42

nrussell

18,382
4
47
60

asked Apr 19 '16 at 12:39

Hossein Yousefi

Did you try specifying a driver? [This](https://dreamtolearn.com/ryan/data_analytics_viz/92) may be helpful. – nrussell Apr 19 '16 at 12:44
@nrussell Not actually how can i do that? – Hossein Yousefi Apr 19 '16 at 12:53

Can not Connect to a database on Redshift in R by RODBC package

0 Answers0