How to enable Microsoft Access Driver (*.mdb, *.accdb) in Microsoft Azure server?

How do I connect to a MS Access (32 bit) database using JDBC on the Eclipse platform?

• I created a database ("Flights.mdb", but that doesn't matter. I can always save it in .accdb format) using Microsoft Access 32-bit. Now I want to access it using Java. Most answers I found online told me to use the odbcad32.exe driver in c:\Computer\sysWOW64 to create a DSN, but When I tried doing it using that method, I got the following error: Connect error: java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application So obviously, there's a 32-bit and 64-bit architecture mismatch somewhere. Can someone please help me figure out where?

• Answer:

  you have to connect through jdbc odbc bridge your ODBC DNS should be 64 bit if you are on 64 bit system.