This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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!