2

I have a java application that uses access database. My PC has 64-bit Operating System, 64-bit Microsoft Office, and 64-bit JDK. I even installed the Access Database Engine x64. Basically everything on it is 64-bit.

In control panel, my target is C:\Windows\SysWOW64\odbcad32.exe and I specified that start in: %windir%\SysWOW64. The problem now this error message that I keep on getting.

java.sql.SQLException:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Does any one know what is causing this error?

Vikdor
  • 23,934
  • 10
  • 61
  • 84
Lazarus
  • 49
  • 8
  • What is causing this error? Is there a specific line of code? Does it happen at runtime or compile? – Scott Oct 01 '12 at 13:24
  • what driver are you using ? can you name it? – Mukul Goel Oct 01 '12 at 13:31
  • @Scott it is a runtime error.The error has nothing to do with a code.Bacause when im using my other lap top which is 32bits everything works fine.@Mukul Goel when i change the target to C:\windows\System32\odbcad32.exe the name of the driver is Microsoft Access driver (*.mdb, *accdb) – Lazarus Oct 01 '12 at 14:18
  • Was the Access database *created* with the 32 bit Access version, *then* you upgraded Access to 64 bit? – Bohemian Jul 11 '13 at 21:05

1 Answers1

2

OK, in that case you will need 64-bit drivers if your Java app is running 64-bit. I believe there is a 64-bit download at the below link:

Microsoft Access Database Engine 2010 Redistributable

Dave Lasley
  • 5,262
  • 1
  • 34
  • 37
Hariom Ahlawat
  • 51
  • 8