[R-sig-DB] trouble connecting to an Oracle DB

[Rajarshi Guha]

Hi, I'm discovering the DBI methods in R and am trying to connect to a
remote Oracle DB using ROracle. However, I'm getting stumped by rthe
connection step. I'm using code of the form:

drv <- dbDriver("Oracle")
con <- dbConnect(drv, 'user/passwd using host:port/SID')

but I get the following error:

Error in oraNewConnection(drv, ...) :
  RS-DBI driver: (ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor
)

Is this an issue with my connection statement? Or is it a problem with
Oracle? I'm using ROracle 0.5.9 and R 2.9.0 (64 bit on OS X Leopard). The
Oracle DB is 10.2.0.3.0

Any pointers would be appreciated

-- 
Rajarshi Guha

	[[alternative HTML version deleted]]