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:
Your help will be greatly appreciated,
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.
Joined: Aug 01, 2005
Thank you Martin, perhaps I should look for another database.