• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Netbeans and .accdb local database

 
induz sat
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I created a local database UserInfo,accdb using MS Access 2007 on my c drive and trying to connect in Netbeans 7.4.
I configured DataSource ODBC using adminTool from Control panel.


I get this error:


I am following this tutorial:
https://www.youtube.com/watch?v=PUeJbLmhuh8

what I am doing wrong?

Do I have to run a server for .accdb ? The database is on my local c drive.
 
Paul Clapham
Sheriff
Posts: 21583
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As of Java 8, the JDBC-ODBC driver (the one you tried to use) is no longer supported. And no, as far as I know there isn't a server which you can run to support Access databases.

You could try to ask the person who produced that video, but I don't think that's likely to produce anything useful. My recommendation would be to use a different database -- Java comes with Derby built in, so you might want to try that instead. I haven't ever used Netbeans myself but I think it's very likely that Netbeans will help you to use Derby in some way, so look for a tutorial about that.
 
induz sat
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for suggestions. Yes I am using java 1.8 and 32 bit MS2007.

I can get connected with mySQL database with jdbc though.

But still waned to know if something to be installed for JDBC-ODBC connections to work with .accdb.

Thanks again

 
Paul Clapham
Sheriff
Posts: 21583
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Your google keywords would be access jdbc driver.
 
induz sat
Greenhorn
Posts: 18
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I came across ucanAccess open source driver to get connection to MS access database.


I added all 5 jar files on my project's Library on Netbeans and the .accdb is getting connected. i use the following for the connection :

and it works


Thanks
 
Paul Clapham
Sheriff
Posts: 21583
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
All right! Thanks for posting back with what you found.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic