[R] connecting to Oracle

whizvast whizvast at gmail.com
Fri Oct 23 21:08:08 CEST 2009


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.




More information about the R-help mailing list