[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Connecting to Ms Access

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
In the below post we have mentioned the best hosting type for startups. Also, check out some of the superlative web hosting companies that are proposing affordable web hosting solutions to host your startup website.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

834 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