Dear All,
I want to connnect R with oracle. I am using RODBC package for this
connection. Following is my code to connect
library(RODBC)
channel <- odbcConnect("Vikrant")
I am getting following error.
1: In odbcDriverConnect("DSN=Vikrant") :
[RODBC] ERROR: state NA000, code 12288, message [Microsoft][ODBC driver
for Oracle][Oracle]ORA-12514: TNS:listener does not currently know of
service requested in connect descriptor
2: In odbcDriverConnect("DSN=Vikrant") :
[RODBC] ERROR: state 01000, code 0, message [Microsoft][ODBC Driver
Manager] The driver doesn't support the version of ODBC behavior that the
application requested (see SQLSetEnvAttr).
3: In odbcDriverConnect("DSN=Vikrant") : ODBC connection failed
I also tried by using another command
library(RODBC)
connection = odbcDriverConnect("driver=ORACLE
Server;server=01hw0038336";DSN=vikrant;UID=system;PWD=password)
Then I am getting folllowing error.
1: In odbcDriverConnect("driver=ORACLE Server;server=01hw088089") :
[RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified
2: In odbcDriverConnect("driver=ORACLE Server;server=01hw088089") :
ODBC connection failed
Any help would be greatly appreciated..
--
View this message in context:
http://r.789695.n4.nabble.com/Error-while-connecting-to-Oracle-using-RODBC-package-tp2288304p2288304.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.
