Hallo Toby, Did you check the ODBC connection independently from R? there is an Oracle tool for this (under Menu Network Administration).
I'm doing fine with a simpler call to odbcConnect: channel <-odbcConnect("MyDSN",uid="myuid",pwd="mypwd") further parameters may not be necessary if you pay attention to only use uppercase names, and I guess that "believeNRows" is superfluous with the latest Oracle ODBC Client(s) if it is well configured. HTH, Marc Mamin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 1:57 AM To: [EMAIL PROTECTED] Subject: [R] ODBC Oracle access 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 session. 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 middle-man. The command I'm attempting to use is: conn<- odbcConnect(dsn='myDSN', uid = "myUID", pwd = "myPWD", case = "oracle",believeNRows=FALSE) 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. Version _ platform i386-pc-mingw32 arch i386 os mingw32 system i386, mingw32 status major 1 minor 7.1 year 2003 month 06 day 16 language R Regards, Toby. Toby Patterson Pelagic Fisheries and Ecosystems CSIRO Marine Research ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help