[R] Error while connecting to Oracle using RODBC package

vikrant vikrant.shimpi at tcs.com
Wed Jul 14 06:57:04 CEST 2010


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.



More information about the R-help mailing list