[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