File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Connecting to Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connecting to Access" Watch "Connecting to Access" New topic

Connecting to Access

Will Reilly

Joined: May 09, 2003
Posts: 24
Hi Ranchers,
I have to connect to a ms access db from a jsp on tomcat(for free without paying for a driver) and after a bit of reading here is where I am at.
After realising that drivers were not for free I discovered that JSK (JDKs) has a free JDBC DBC brige driver bundled with it. Problem is I cant find it and don't know what to do with it when I do. There seems to be a few tutoirals on how to use the JDBC API but not how to set up this free driver. Can anyone point me in the direction of a good tutorial/instructions.
Any help would be great
Joe Ess

Joined: Oct 29, 2001
Posts: 9191

The Java Tutorial: JDBC Basics covers everything except creating the ODBC DSN. That depends on your version of Windows. Find your "Data Sources (ODBC)" tool under the Control Panel or Administrative Tools. Click on "Add", choose "Microsoft Access Driver", give it a name (remember the name, you need it to connect with the bridge), and select a database. That should get you started.

[How To Ask Questions On JavaRanch]
Joel McNary

Joined: Aug 20, 2001
Posts: 1824

You don't event need to set up the ODBC driver, even! Just use this as your connect string:

[ December 05, 2003: Message edited by: Joel McNary ]

Piscis Babelis est parvus, flavus, et hiridicus, et est probabiliter insolitissima raritas in toto mundo.
Nirav Patel

Joined: May 27, 2005
Posts: 22
Well I have the the .mdb file in the same directory, still it's giving the error .
My database string is: .
Also, If my Main class (who is starting the app is in the different dir and from that I am creating an object that intern connect to access, do I need to give ANY path relative to that MAIN class? Or that will work...


----<br />Nirav Patel<br />Software is the bottleneck in the digital world!
I agree. Here's the link:
subject: Connecting to Access
It's not a secret anymore!