Solved

Connecting to Ms Access

Posted on 2003-12-05
5
515 Views
Last Modified: 2010-04-01
Hi guys,
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

0
Comment
Question by:williery10
  • 3
  • 2
5 Comments
 
LVL 15

Expert Comment

by:jimmack
ID: 9882649
Try this question for starters.  If you're still having problems, please post again ;-)

http://www.experts-exchange.com/Web/Web_Languages/JSP/Q_20505968.html
0
 

Author Comment

by:williery10
ID: 9882770
Hi Jim,
thanks for the reply. Had a look at the post and there was link tothe sun tutorial on this. Heres what the Sun tutorial says on it.

*********************
Install a driver on your machine.
Your driver should include instructions for installing it. For JDBC drivers written for specific DBMSs, installation consists of just copying the driver onto your machine; there is no special configuration needed.

The JDBC-ODBC Bridge driver is not quite as easy to set up. If you download either the Solaris or Windows versions of JDK1.1, you will automatically get the JDBC-ODBC Bridge driver, which does not itself require any special configuration. ODBC, however, does. If you do not already have ODBC on your machine, you will need to see your ODBC driver vendor for information on installation and configuration.
*************************

This is pretty much what I already knew. It doesn't say what to do with ODBC and that is I am stumped. What to do with  ODBC, I just don't know and cant find any instructions

any suggestions are really welcome
Williery
0
 
LVL 15

Accepted Solution

by:
jimmack earned 50 total points
ID: 9882811
To configure the ODBC side, you'll need to look at:

Control Panel>Administrative Tools>Data Sources (ODBC)

on the machine with Access installed.  (Don't ask me for any more here, I use Linux ;-))

Here's a little bit more info:

http://www.javaworld.com/javaworld/javaqa/2000-09/03-qa-0922-access.html?
0
 

Author Comment

by:williery10
ID: 9883115
Hi Jim
cheers for that,
actually copped it on just after i made the second post and followed an odbc tutorial. Anyway cheers for your help
Williery
0
 
LVL 15

Expert Comment

by:jimmack
ID: 9883161
;-)
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now