Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

MS access  RSS feed

 
lokesh rajarathnam
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all

I want to know how to get connect with MS Access(jdbc odbc bridge)


please any one give me in simple compilable program in java
 
Rob Spoor
Sheriff
Posts: 20893
81
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
First you'll need to load the driver. It's already shipped with the JVM, and it's "sun.jdbc.odbc.JdbcOdbcDriver".

Next you need the connection string: "jdbcdbcRIVER={Microsoft Access Driver (*.mdb)};DBQ=" followed by the Access file.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!