ODBC Drivers in Wnidows 7

Question

HOW DO I CONFIGURE ODBC CONNECTION IN WINDOWS 7????

I am building J2EE  application where i have used a access database using system DSN.while connecting inside servlet,it shows "

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

From Articles i came to know about configuring ODBC administrator to odbcad32.exe under %WINDIR%\SYSWOW64...I tried this under properties tab of ODBC in control panel...

But The error is still coming as

 

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

Guide me..THANKS

Answer 1

Hi,

From your description, I think both your application and Windows 7 are 64-bit, right?

If so, the error is caused by that there is no 64-bit ODBC drivers for Access, please refer to another similar thread:

http://social.answers.microsoft.com/Forums/en-US/addbuz/thread/be8c0ad4-d8fd-48e0-9026-b95d84135820

Or you may change your application to 32-bit.

Since your problem is not relevant to SQL Server, I would suggest you post your issues in Office forums.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

Is your application 32-bit or 64-bit?
If it is 64-bit, could you install the 64-bit ACE ODBC driver for Office 2010 Beta and try again?

Thanks,
Ming.
WDAC Team, Microsoft.

---

Pak-Ming Cheung - MSFT

Answer 3

How exactly do I do this? I have the .dll file that is used in Office 2010 X64 I believe.

Thanks

John

Answer 4

You can install 64 bit ACE ODBC Driver with these instructions : http://blogs.msdn.com/sqlblog/archive/2009/12/29/how-to-connect-to-file-based-data-sources-microsoft-access-microsoft-excel-and-text-files-from-a-64-bit-application.aspx

Hope that helps

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 5

Hi there:

My problem is that I am using Office 2007 which preinstalls a 32 bit driver for access and the 64 bit driver will not install. Is there a way to uninstall the 32 bit driver?

Thanks

John