• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • paul wheaton
  • Ron McLeod
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:

Java and DSN-LESS Access Database, How to Impliment?

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am working on a Java application in Netbeans, and I want use  Access Database (portable with the application) I am Totally confused with the Java Path Gimmicks. I tried puting the mdb file in all the conceivable path, In the src folder, Library folder, build folder everywhere. Java doesn't see it. Jdbc driver is in the library folder. I am doing a trial and error exercise, sometimes it shows classNotFound exception, sometimes it says No suitable driver found. Can anybody here guide me please?
 
Rancher
Posts: 5114
38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This is more a MS tool setup problem than a Java programming problem.  I looked at some access DB files I tested with years ago (2001).  With the .mdb file there was also a .dsn file.  The code didn't work with Java 10 but it did  work with Java 6.  I had several .mdb files without .dsn files.  The  .dsn files are text.  I was able to copy and change the one .dsn file so that it worked with the other .mdb file.
On Win 10 I used the ODBC Data Sources app found in the Administrative Tools folder in the Control Panel.  I'm not sure of the exact steps I took in the app but when finished my old programs run with java 6 were able to read and display the contents of the .mdb files.
 
reply
    Bookmark Topic Watch Topic
  • New Topic