I've inherited a system whereby a JAVA JAR file connects to a local database. This works absolutely fine on Win x86 but we're unable to get working on any Win x64.
When running the batch file(text below) I get presented with the error message "Database Access fails! Mure sure 'database.mdb' is in your local path. [Microsoft][ODBS Driver Manager] Data source name not found and no default driver specified"
I've had a look in ODBC sources but I don't have to add anything for Win x86 so have no idea of what to enter for x64.
I've read a few things about different drivers for x64 but have had no luck with any fixes suggested. I've tried adding the program and DB path to the path of windows environmet but still nothing.
I'm a total newb when it comes to this and have no experience at all so i'm hoping someone has come across this before and has an easy solution!
The batch file we run is as follows:
set JAVA_HOME=c:\program files\java\jreVERSION_NUMBER\bin
start "" javaw -jar lib/database.jar