• 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:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

.accdb (Access Database) integration with NetBeans Java Program

 
Author
Posts: 587
6
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm trying to connect to a .accdb database through a Java program and I'm getting this error:

Got an exception!
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Here is the code:



Note that I was advised against Java 8 and 64 bit, so I'm using JDK 7 and passing this switch: -D32.

But still no dice.

Additionally, I installed this:

Connector/ODBC 5.3.4
http://dev.mysql.com/downloads/connector/odbc/

But I have nothing specified in Maven.

I'm not sure exactly where/how to enable the driver and connection.

Please advise.

-- Robert

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, i just join the ranch to reply you.

Now, I'm using Java 8 to develop a program with
an accdb file. After a deep search, I find a
library called UCanAccess, so try it. It's not hard
to use and there's enough information on google for it.
Be careful with the dependecies too.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


This works only for *.mdb and not *.accdb .

Used jdk1.6...
 
Bartender
Posts: 7645
178
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to the Ranch, Muhammad.

After 9 years, it's unlikely that Robert is still waiting for a response.

Note that the JDBC/ODBC bridge was removed from the JDK years ago, and is no longer a viable option (if it ever was - it had a reputation for being buggy, and of course not being thread-safe). Much better options such as https://sourceforge.net/projects/jackcess/, https://github.com/spannm/ucanaccess (both open source) and http://www.hxtt.com/access.html (commercial) exist.
 
It is an experimental device that will make my mind that most powerful force on earth! More powerful than this tiny ad!
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic