Need some support to connect to Database using R Libraries. I am getting the following error
'Error: nanodbc/nanodbc.cpp:983: 00000: [unixODBC]Could not connect to the server;
Could not connect to remote socket immediately'
Connecting string I used :
con <- DBI::dbConnect(odbc::odbc(),
driver = "PostgreSQL",
database = "dbname",
UID = "username",
PWD = "password",
host = "RDS db available in Amazon",
port = 5432)
Kindly note that Its a fresh installation and I am trying to connect 1st time with database.