Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem with 64 bit Windows ODBC

 
Alejandro Barrero
Ranch Hand
Posts: 361
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are 2 versions of ODBC to worry about on 64-bit Windows machines: the 32-bit version and the 64-bit version. I have a program that uses a non-DSN connection to an Access database (I know, people don't like Access, but I only have to distribute a single file). My problem is that my program fails with an exception "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" on a Widows 7 machine. I can solve the problem by installing 32 bit Java, but I would like a solution for any type of Java. My code is:
 
Tim Moores
Saloon Keeper
Posts: 3323
61
 
Alejandro Barrero
Ranch Hand
Posts: 361
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you very much Tim. It certainly looks like that should work; however, I used

in my code but I still got the same exception. I am befuddled.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Alejandro Barrero wrote:(I know, people don't like Access, but I only have to distribute a single file).

I'm not expert on this area, but as far as I know, there are several embedded databases available for Java, which have the added benefit of being 100% portable and (most importantly) don't make you use the problematic ODBC bridge. Some of them store the data in a single file, or just a few files. If the single file requirement is your only concern, and can be reasonably converted into "a few files", I'd suggest to try these out (java embedded single file database is what I tried). You might be even able to find truly single-file databases, but that might constraint your options too much.
 
Alejandro Barrero
Ranch Hand
Posts: 361
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Martin, perhaps I should look for another database.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!