Apologies, but after a fair amount of digging, I still only have a foggy understanding of the cause of this problem, due to my own ignorance.
I hope to use RODBC package to connect to an Access DB when running 64 bit Win7 (R version 2.11.1, 64 bit). I have successfully done this before on a winXP machine. Currently I am unable to establish a connection using odbcConnect("") (I am able to establish a MySQL connection just fine), which I suspect may be a result of the driver setup location varying for 64 bit Win7 and 32 bit Win7. That is, to create a ODBC connection when running 64 bit Win7 the default executable file appears to NOT be the correct c:\windows\sysWOW64\odbcad32.exe but rather is c:\windows\system32\odbcad32.exe. odbcConnect returns a Microsoft error of "specified DSN contains an architecture mismatch between the Driver and Application" I am guessing wildly here, but I wonder if odbcConnect is looking in the wrong directory for my MS Access driver, as Microsoft hasn't even managed to make the default location one is directed to to manage ODBC connections via the control panel to be correct? I also suspect that if I installed a 32 bit version of R, odbcConnect might correctly find the location of my MS Access driver. Clearly I'm a pretty confused about this, but I hope one of you old pros on RODBC that is knowledgeable of the peculiarities of 64 bit Win 7 can give me some guidance. Thanks in advance - Peter [[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.