Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

32 bit / 64 bit ODBC dilemma

883491Mar 29 2012 — edited Mar 29 2012
I have been trying to figure out why my JAVA application works fine on some machines but not on others when the program tries to connect to an ACCESS database. I have read up on the different drivers that appear if you bring up the 32 bit list using c:\Windows\SysWOW64\odbcad32.exe versus the 64 bit list from the control panel.
On a machine that has the problem, I get this error message when trying to connect:
Data source name not found and no default driver specified
The code is using this connection string: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\DataBases\ Traing3.mdb;
If I go to the 32 bit drivers and create a DSN and then use this connection string: jdbc:odbc:MyDSNdb, I get the following error:
The specified DSN contains an architecture mismatch between the Driver and the Application

What I have found is the machines that do not work have a 64 bit JRE installed and the ones that work have a 32 bit JRE. I have taken an non-working machine, uninstalled the 64 bit JRE and replaced it with the 32 bit JRE and the program runs fine using both connection strings listed above.

My questions is: What do I need to do in order to make the application run which has a 64 bit JRE? I would also like to add, that these machines typically are running 32 bit MS Office bundles.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2012
Added on Mar 29 2012
1 comment
775 views