wood burning stoves 2.0*
The moose likes JDBC 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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting to Access" Watch "Connecting to Access" New topic
Author

Connecting to Access

Will Reilly
Greenhorn

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
Williey
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8927
    
    9

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.


"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
Joel McNary
Bartender

Joined: Aug 20, 2001
Posts: 1821

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
Greenhorn

Joined: May 27, 2005
Posts: 22
Hi,
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...

Nirav


----<br />Nirav Patel<br />Software is the bottleneck in the digital world!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting to Access