• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

.accdb (Access Database) integration with NetBeans Java Program

 
Author
Posts: 587
6
  • 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

 
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.
 
    Bookmark Topic Watch Topic
  • New Topic