Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

.accdb (Access Database) integration with NetBeans Java Program

 
Robert James Liguori
Author
Ranch Hand
Posts: 575
6
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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!