Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Connecting to Ms Access

Posted on 2003-12-05
5
Medium Priority
?
524 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 200 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

610 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