• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with 64 bit Windows ODBC

 
Alejandro Barrero
Ranch Hand
Posts: 360
  • 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
Bartender
Posts: 3129
50
 
Alejandro Barrero
Ranch Hand
Posts: 360
  • 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: 360
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Martin, perhaps I should look for another database.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic