Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting to Access

 
Will Reilly
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 9258
10
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Joel McNary
Bartender
Posts: 1840
Eclipse IDE Java Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Nirav Patel
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic