1

i have followed these steps to install Access Database Engine, configure the ODBC data source and create a user DSN abc linked to abc.mdb: https://stackoverflow.com/questions/6721702/windows-7-64-bit-odbc-drivers-for-ms-access-missing and How to read data from Microsoft Access .accdb database files into R?

No issues.

However, odbcConnect("abc") is giving me this error: The specified DSN contains an architecture mismatch between the Driver and Application

Community
  • 1
  • 1
SilverSpoon
  • 655
  • 4
  • 8
  • 17

1 Answers1

2

This issue is with regards to 32bit v 64 bit i think. Is your R 32 bit or 64 bit. It is likely you created a 32 bit DSN. c:\windows\sysWOW64\odbcad32.exe will create a 64 bit version. By default control panel points to %windir%\system32\odbcad32.exe which would be the 32bit version

Paul Hiemstra
  • 59,984
  • 12
  • 142
  • 149
shhhhimhuntingrabbits
  • 7,397
  • 2
  • 23
  • 23
  • my R is 64 bit and i have already changed to c:\windows\sysWOW64\odbcad32.exe. – SilverSpoon Jun 05 '12 at 06:08
  • im using 64 bit Access, 64 bit Access Database Engine and 64 bit R – SilverSpoon Jun 05 '12 at 07:51
  • Strangely enough, now i am running under C:\Windows\System32\odbcad32.exe and everything is fine with 64 bit R while SysWOW64\odbcad32.exe only works for the 32 bit version. – SilverSpoon Jun 05 '12 at 08:01
  • 1
    WOW64 is for the 32-bit version on 64-bit, the System32/ ones are for the native architecture, it's easy to remember once you realize how hard it is to remember – mdsumner Jun 05 '12 at 12:27
  • 1
    Just to add on, i had to re-install MS Access to 64 bit version and then installed MS Access Database Engine for 64 bit version. – SilverSpoon Jun 06 '12 at 01:13