CODEWITHSUNDEEP
ms-accessjdbc64-bitdriversqlexception
shane87
shane87

Reputation: 3120

Is there a 64bit driver for Microsoft Access?

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

I get the following error when I try to connect to my Microsoft Access database from an eclipse project using jdbc.

I am using 64bit windows and microsoft office 2007.

any help on this matter would be great.

Upvotes: 3

Views: 8260

Answers (2)

Fionnuala
Fionnuala

Reputation: 91376

Access 2010 has 64 bit drivers and can be downloaded http://www.microsoft.com/downloads/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

Upvotes: 0

David
David

Reputation: 25470

64bit applications can't play with the 32bit Jet (Access) drivers. You need to fix this.

Two ways:

The hard, crazy cat lady way is to route the queries through something that can go both ways, such as installing the 32bit version of SQL Server Express, writing stored procedures in it to query the Access database, and then call the stored procedures from your 64bit application.

The easy, "correct", but potentially buggy for a short while way is to download and install the beta version of the Office 2010 Jet drivers (redistributable), which finally support 64bit mode. They can be downloaded from Microsoft here.

Upvotes: 2

Related Questions