Solved

Connecting to Ms Access

Posted on 2003-12-05
5
517 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

If you thought ransomware was bad, think again! Doxware has the potential to be even more damaging.
This problem is more common than not and I will show you some things to check to solve this problem.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 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