• Register
0 votes
442 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”

7 5 2
3,870 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.

9 7 4
38,600 points

Related questions

0 votes
1 answer 106 views
106 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 88 views
88 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 6 views
6 views
Problem: I am stuck with this ... Please help me that how to deal with this error? The operating system is not presently configured to run this application
asked Mar 18 Ifra 24.4k points
0 votes
1 answer 10 views
10 views asked Feb 21 Akhil k 1.3k points
1 vote
1 answer 2 views
2 views
Problem: Please help me. How can I solve it? there was a mismatch between the processor architecture of the project being built "msil"
asked 6 days ago MUHAMMAD MUNEEB 80k points
0 votes
1 answer 4 views
4 views
Problem: Hello ... Can anyone tell me that why I got this error? run time error 3146 odbc call failed
asked Mar 26 Ifra 24.4k points
0 votes
1 answer 38 views
38 views
Problem: Why I got this error: Call to undefined function odbc_connect() php 7? ny idea on what I need to fix this. I am new in c++. Thanks in advance.
asked Mar 13 jasimchaudary 1.5k points
0 votes
1 answer 21 views
21 views
Problem: microsoft ole db provider for odbc drivers error '80004005'
asked Feb 18 charles mathews 5.5k points
0 votes
1 answer 6 views
6 views
Problem: I am facing a common error as follows: The specified cgi application encountered an error and the server terminated the process .
asked Mar 15 Wafa Abu Yousef 6.1k points
0 votes
1 answer 1.3K views
1.3K 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