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 on
64-bit R. [See below for the transcript.]
The comments in the post to which you referred concerned how to set up ODBC
on a 64-bit system when one had a 32-bit database and 32-bit R. To access
the right ODBC for that setup, you have to grab it from the directory
mentioned in the post. As mentioned there, I put a shortcut to it on my
desktop so I don't have to go on a fishing expedition to find it again. As
far as I can tell, there has to be coordination among R, the database and
ODBC in the sense that they all must be 32-bit or all 64-bit.
Since I don't use databases all that often, my dodge is to read the files in
with 32-bit R, save them as R binaries and then work with those in 64-bit R
- but I've got enough disk space and RAM to afford to do that. Your mileage
may vary.
64-bit R:
library(RODBC)
ch - odbcConnect('gameday10', uid = 'dennis', pwd = '')
Warning messages:
1: In odbcDriverConnect(DSN=gameday10;UID=dennis) :
[RODBC] ERROR: state IM014, code 0, message [Microsoft][ODBC Driver
Manager] The specified DSN contains an architecture mismatch between the
Driver and Application
2: In odbcDriverConnect(DSN=gameday10;UID=dennis) :
ODBC connection failed
32-bit R:
library(RODBC)
ch - odbcConnect('gameday10', uid = 'dennis', pwd = '')
sqlTables(ch)
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
1 gameday10 atbat TABLE
Hope this clarifies matters somewhat.
Dennis
On Fri, Dec 17, 2010 at 11:48 AM, Alexander Shenkin ashen...@ufl.eduwrote:
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) with 64-bit R via RODBC. There seem to
be some conflicting accounts as to whether or not this is possible.
Ripley's ODBC Connectivity PDF and the odbcConnect docs indicate it is not
possible (copied below for reference). However, this thread (
http://r.789695.n4.nabble.com/RODBC-Access-Excel-driver-location-for-64-bit-Win7-td2542550.html
)
seems to indicate that it may be possible by using
c:\windows\sysWOW64\odbcad32.exe:
For 64-bit WIn 7, I needed to use the ODBC in
c:\windows\sysWOW64\odbcad32.exe. I configured RODBC in the 'usual' way for
the 64-bit ODBC (i.e., per the R Import/Export manual) and everything is
fine.
I have tried creating DSN's using c:\windows\sysWOW64\odbcad32.exe and
referencing those with RODBC, but I come up with errors:
library(RODBC);
channel - odbcConnect(myDSN);
Warning messages:
1: In odbcDriverConnect(DSN=myDSN) :
[RODBC] ERROR: state IM014, code 0, message [Microsoft][ODBC Driver
Manager] The specified DSN contains an architecture mismatch between the
Driver and Application
2: In odbcDriverConnect(DSN=myDSN) : ODBC connection failed
If anyone knows any more about this issue, I would be grateful for the
information!
Thanks,
Allie
R 2.12.0
Windows 7 Pro x64
Access 2007
from Ripley's ODBC Connectivity
32-bit Windows drivers for Access 2007 and Excel 2007 are bundled with
Office 2007 but can be installed separately via the installer
AccessDatabaseEngine.exe available from The Access/Excel 2010 versions
at ... have a 64-bit version: however the 64-bit drivers cannot be
installed
alongside 32-bit versions of Office (as far as we know, and defnitely not
for Office 2007).
odbcConnect docs:
You must have the 32-bit drivers when using 32-bit R and the 64-bit
drivers
when using 64-bit R: otherwise there will be a cryptic message about a
driver not being found. And the 64-bit drivers cannot be installed
alongside
32-bit Microsoft Office, and vice versa.
[[alternative HTML version deleted]]
__
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.
[[alternative HTML version deleted]]
__
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.
