aspose file tools*
The moose likes JDBC and the fly likes MS access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MS access" Watch "MS access" New topic
Author

MS access

lokesh rajarathnam
Ranch Hand

Joined: May 17, 2007
Posts: 35
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

Joined: Oct 27, 2005
Posts: 19762
    
  20

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.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MS access