• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

.accdb (Access Database) integration with NetBeans Java Program

 
Robert James Liguori
Author
Ranch Hand
Posts: 553
5
Java Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • 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

 
Oscar Vicente
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • 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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic