• Register
Log In
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”

3.9k 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.

36.1k points

Related questions

0 votes
1 answer 26 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 23 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 427 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
1 vote
1 answer 16 views
Problem: I have got an assignment from my online java class and doing the assignment and can't quite figure out what I'm doing wrong. I have to write a program that finds the sum of all squares between 1 and 100. As part of the assignment, I'm required to use a "while" ... ); a++; sum = (sum + a); } System.out.println(sum); } Thanks for your positiveness and effort. I must recognise your help.
asked Mar 28 Gavin 15.2k points
1 vote
1 answer 21 views
Problem: Hello, the good people of Kodlogs, I am struggling with confusion for the last hour. What is the basic and main difference between the (==) and .equal() in java? Can I use the operator == to check whether two variables refer to the same array? If it is possible, please give me an example. Both usages of them are much appreciated in a single program. Thanks.
asked Mar 17 Gavin 15.2k points