Establishing a connection to dashDB using RODBC is not working.
When trying to set up a connection to dashDB from the rstudio ide on DSX I get this error:
[RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified
This is after filling out this:
dsndriver <- "{IBM DB2 ODBC Driver}"
dsndatabase <- "BLUDB" # e.g. "BLUDB"
dsnhostname <- "<Enter Hostname>" # e.g.: "awh-yp-small03.services.dal.bluemix.net"
dsnport <- "50000" # e.g. "50000"
dsnprotocol <- "TCPIP" # i.e. "TCPIP"
dsnuid <- "<Enter UserID>" # e.g. "dash104434"
dsn_pwd <- "<Enter Password>" # e.g. "7dBZ39xN6$o0JiX!m"
connpath <- paste("DRIVER=",dsndriver,
";DATABASE=",dsndatabase,
";HOSTNAME=",dsnhostname,
";PORT=",dsnport,
";PROTOCOL=",dsnprotocol,
";UID=",dsnuid,
";PWD=",dsnpwd,sep="")
conn <- odbcDriverConnect(conn_path)
conn
So this code does not work for me.
Is there anything I am missing here? I imported the RODBC library
-
Christian Rua commented
i have same problem, somebody can help me?
-
Christian Fonseca commented
I have the same problem. Please provide support with this. Thanks!!!