• Register
0 votes
604 views

Problem :

I want to connect to the database made by MS Access using the Java, but I am unable to manage it. I am using the ODBC and I am facing below exception:

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

3.9k points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

A architecture in your error is referring to a 32 vs 64 bits. So my solution was to find out which of the my apps is running under the (Access) which 2010 is 32b. I found this by simply looking in a Process tab of my Task Manager where my all 32b processes have * 32 at the end of their names.My control panel will launch a 64 bit version of the ODBC from below path:

c:\windows\system32\odbcad32.exe

And my 32 bit version is on below path:

c:\windows\sysWOW64\odbcad32.exe (easiest to just copy and paste into the run dialog)

So I just set up the DSNs with the names ending with 32 and 64 in each of my corresponding ODBC control panels (i.e. Administrator) that pointed to a same thing. Then, I just picked a correct one based on whether my app is using 32b or 64b.

Hope this will solve your error.

38.6k points

Related questions

0 votes
1 answer 48 views
48 views
Problem: Can anyone tell me the solution to this problem > Odbc driver manager the specified dsn contains an architecture mismatch
asked May 7 ummeshani 10.8k points
0 votes
1 answer 9 views
9 views
Problem : The specified dsn contains an architecture mismatch
asked Jun 27 Siam55 110k points
1 vote
1 answer 21 views
21 views
Problem: If some one know that how to resolve this connection error then please comment on this: Architecture mismatch between the driver and application.
asked Apr 26 PkGuy 25.9k points
0 votes
1 answer 13 views
13 views
Problem: What should I do with this? >The specified dsn contains an architecture mismatch oracle
asked May 9 Sawyer Parviz 168k points
0 votes
1 answer 279 views
279 views
Problem : I want to open a program for the first time on Windows XP Pro that uses PostgreSQL 9. I am facing an error message that says : A problem was encountered while trying to log into or create the production database. Details: [Microsoft][ODBC Driver Manager] ... = MSDASQL". Changing this entry alters a error message I get to "Provider cannot be found, it may not be properly installed".
asked Jan 17, 2020 jwilliam 3.9k points
0 votes
1 answer 231 views
231 views
Problem : I am facing following PostgreSQL 9 error [microsoft][odbc driver manager] data source name not found and no default driver specified
asked Nov 18, 2019 peterlaw 6.9k points
0 votes
1 answer 9 views
9 views
Problem: Microsoft access driver (*.mdb *.accdb)?
asked Jul 23 Mezbah 130k points
0 votes
1 answer 15 views
15 views
Problem: Microsoft odbc driver 13.1 for sql server.
asked Jul 17 akhi 125k points
0 votes
1 answer 6 views
6 views
Problem: Sql server native client 10.0 odbc driver.
asked Jul 17 akhi 125k points
0 votes
1 answer 3 views
3 views
Problem : Microsoft sql server odbc driver for linux
asked Jul 14 Siam55 110k points