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

2012-02-17 Thread 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

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

2010-12-17 Thread Dennis Murphy
Hi: Since I'm the culprit of that post, is your Access database on your 64-bit machine or is it on a remote server? In my case, I have 32-bit MySQL on a 64-bit Win7 system and I've used RODBC several times to upload a file to R, but it was to 32-bit R (I just checked to be sure). It doesn't work o

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

2010-12-17 Thread Alexander Shenkin
Hello Folks, I do hope this is the correct place to post (and not in R-SIG-DB). I have spent the better part of a day searching for an answer to this question, and have yet to resolve it. I am trying to query an .accdb Access database (with 32-bit Office 2007 currently residing on the machine) w