Solved

Connecting to Ms Access

Posted on 2003-12-05
5
519 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Originally, this post was published on Monitis Blog, you can check it here . Websites are getting bigger and more complicated by the day. Video, images and custom fonts are all great for showcasing your product or service. But the price to pay in…
This article discusses how to implement server side field validation and display customized error messages to the client.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

733 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