Connecting a Microsoft Access Database to Java using JDBC - error

Question

I'm trying to get information from a MS Access database using Java.

First, I added ODBC from here

C:\Windows\SysWOW64\odbcad32.exe

since I'm working on Windows 7.

and then , I used this code

String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);         

String db = "jdbc:odbc:DataSource";
con = DriverManager.getConnection(db);

But I got this error

[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

after googling this error, I think the problem is that I'm working on Windows 7 64-bit and MS Office 32-bit. The question is how can I solve this problem without having MS Office 64-bit?

Thank you.

Adel Boutros · Accepted Answer · 2012-03-08 23:45:52Z

1

On the almight msdn, I quote:

If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver, for example, Driver do Microsoft Access (*.mdb), you will receive the following error message:

The specified DSN contains an architecture mismatch between the Driver and Application

To resolve this error, use the 32-bit odbcad32.exe to configure or remove the DSN.

answered Mar 8, 2012 at 23:45

Adel Boutros

10.3k8 gold badges58 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user1178619 Over a year ago

Thanks, but how can I use the 32-bit viersion of odbcad32.exe? I tried to use this c:\windows\system32\odbcad32.exe, but when the ODBC is opened, and when I press Add button, I get nothing in the Create New Data Source dialog. So, I can add a new drive.

user1178619 Over a year ago

As I have read, I have to use C:\Windows\SysWOW64\odbcad32.exe because I'm working on Windows 7!

Adel Boutros Over a year ago

@user1178619 did you read the entire link? the 32 in odbcad32.exe doens't mean it is version 32-bit. You have to maybe download the 32-bit version of odbcad32.exe if you don't have it.

Collectives™ on Stack Overflow

Connecting a Microsoft Access Database to Java using JDBC - error

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related