Hi, useR- I am connecting to Oracle database using RODBC, but keep getting this error message:
> library(RODBC) > channel <- odbcConnect(dsn="abc", uid="abc", pwd="abc", case='oracle') Warning in odbcDriverConnect(st, ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Warning in odbcDriverConnect(st, ...) : ODBC connection failed Do you know what needs to be corrected? I am a beginner in DB. There was a post for the exact same message, but no one replied. Hope this time someone else help me! Thank you. -- View this message in context: http://www.nabble.com/connecting-to-Oracle-tp26031761p26031761.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.