[R] ODBC Oracle access

Toby.Patterson@csiro.au Toby.Patterson at csiro.au
Tue Aug 26 01:56:34 CEST 2003

Hi all, 
I'm having trouble connecting to an oracle database using RODBC under
winXP. Unfortunately I can't really send a reproducable error as the
initial call to odbcConnect seems to hangs R and I have to kill the

I have been using RODBC to sucessfully connect to an MS Access DB that
has tables linked through to the oracle database in question and that
seems to work OK but it would be preferable to cut out the MS access

The command I'm attempting to use is: 

conn<- odbcConnect(dsn='myDSN', uid = "myUID", pwd = "myPWD", case =

I wouldn't be surprised if there is an issue with the dsn configuration
and not R (though I cant find it) so any tips as to things that I should
check there would also be gratefully received. 

platform i386-pc-mingw32
arch     i386           
os       mingw32        
system   i386, mingw32  
major    1              
minor    7.1            
year     2003           
month    06             
day      16             
language R   


Toby Patterson
Pelagic Fisheries and Ecosystems
CSIRO Marine Research

More information about the R-help mailing list