File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes MS Access Driver  for servlets? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "MS Access Driver  for servlets?" Watch "MS Access Driver  for servlets?" New topic

MS Access Driver for servlets?

Agnes Lapka

Joined: Dec 26, 2000
Posts: 23
I'm new to servlets and I'm very confused.
I'm trying to write a servlet that will write data to Access Database. I have the Microsoft Access Driver which comes with Windows ( Settings -> Control Panel -> ODBC Data Sources ).
I thought I could use it in my servlet until I've heard that I must include the path to a JAR file containing the Driver in my CLASSPATH settings. Where can I get a JAR file with Access Driver? Can I use the Driver I already have or do I need to download a new one? I would be grateful for suggestions.
TIA - A.
Marcos Maia
Ranch Hand

Joined: Jan 06, 2001
Posts: 977
just register your database at settings -> control panel -> odbc data as you said and than use the jdbc dbc brige
String url = "jdbc dbc:yourRegisteredDB";
Connection con = DriverManager.getConnection(url, "username", "password");
take a look at:

[This message has been edited by Marcos Maia (edited August 02, 2001).]
Agnes Lapka

Joined: Dec 26, 2000
Posts: 23
Thanks, Marcos. I'm going to try that right away.
Thanks for your help. A.
I agree. Here's the link:
subject: MS Access Driver for servlets?
It's not a secret anymore!