This was my experience connecting remotely to an Oracle database with R 64 bit on Windows 7 64-bit. I already had a configuration for 32-bit R and 32-bit Oracle using RODBC that worked, but I wanted to only use R-64. Here was what I did that works:
This was assuming an install to the root c:\ and windows in c:\windows Download and install (I did full administrator install): Oracle Client (x64) 11.2 ... http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html (I called Orahome2) Open Oracle Net Manager in new installation (OraHome2) Go to Service Naming, should be empty, go to Edit, and Create Name connection name something different from the 32-bit version host name : the domain name or IP address Service name must still be the same as the 32-bit as before Keep default port 1521 Next go to C:\windows\system32\odbc32.exe (Oddly this is the 64-bit version) Run this and set up a new system DSN connection Call this whatever, but TNS Service ID must be the same as your connection named above Hit Test connection, should work. When running in R-64 bit RODBC package: I had to use the optional odbcConnect(“databasename”,uid=””,pass=””,believeNRows=FALSE) This worked for me! Cheers, Dana -- View this message in context: http://r.789695.n4.nabble.com/RODBC-for-64-bit-R-with-32-bit-Access-tp3093030p4398497.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.