[R] RODBC for 64-bit R with 32-bit Access

[GreatDana]

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.