ODBC Driver Access 2010

Solved
Maknash Posted messages 701 Status Membre -  
 Lamine -
Hello,

For my end-of-year project (I'm starting well in advance on Java), I need to create a management program (for example, for a video game store) with databases.
I've already created a good part of the program, but it runs on my old PC but not on my new one!
Actually, for the moment, I'm doing it for MS Access, but on one of the two PCs, I get an ODBC error.
On the PC that works, I have Windows 7 Ultimate and Office 2007, while on the other (a new one), I have Windows 7 Home Premium but Office 2010.
I link my database the same way on both PCs, but on the new one, Eclipse gives me this error:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified data source (DSN) has an architecture mismatch between the driver and the application


I've looked everywhere, and I can't find the error since it works on the other PC...
So here I am relying on you because apparently the error comes either from Windows 7 Home Premium or from Office 2010.

Thank you in advance

Configuration: Windows Seven
SRWare Iron
Firefox 3.5

--
I was thinking that the best would be to pretend to be deaf-mute.
The speed of light is faster than sound, which is why we appear intelligent before we appear dumb.

1 réponse

Maknash Posted messages 701 Status Membre 184
 
Here I found the solution, in fact I was running the 64-bit version of ODBC (the one in the system32 folder).
The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

My source: https://support.microsoft.com/fr-fr/help/942976/odbc-administrator-tool-displays-both-the-32-bit-and-the-64-bit-user-d
--
I thought the best thing would be to pretend to be deaf-mute.
The speed of light is faster than the speed of sound, that's why we appear intelligent before we appear stupid.
21
hswd pro
 
Thank you. It helped me a lot.
0
belial1988
 
Thank you, it helped me as well.
0
Kimy_Ire
 
Thank you! Awesome! =) +1 for me too!
0
Lamine
 
Hello, I did the operation. On some PCs, the app works, and on others, I get the message: [Microsoft][ODBC Driver Manager] The specified data source (DSN) has an architecture mismatch between the driver and the application.
0