• Register
0 votes

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”

7 5 2
3,870 points

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:


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.

9 7 4
38,600 points

Related questions

0 votes
1 answer 44 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 jwilliam 3.9k points
0 votes
1 answer 52 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 898 views
Problem : I am trying to host the asp.net 5 application on the azure, the code is complied for the beta8, my application runs fine on the local environment but when i publish the code on the azure site. I am facing a common error as follows: "The specified CGI application encountered an error and the server terminated the process."
asked Nov 27, 2019 alecxe 7.5k points
0 votes
1 answer 6 views
What is the difference between web application and enterprise application?
asked Oct 11 sikandar 2.4k points
0 votes
1 answer 7 views
7 views asked Oct 28 miki 1.6k points