Solved

Free JDBC Driver for MS Access

Posted on 2004-08-12
13
324 Views
Last Modified: 2008-03-03
Hello.

Is there any free JDBC MS ACCESS driver.

Please reply soon.
0
Comment
Question by:abbas1982
13 Comments
 
LVL 35

Accepted Solution

by:
girionis earned 20 total points
ID: 11782338
0
 
LVL 35

Expert Comment

by:TimYates
ID: 11782350
The sun odbc/jdbc bridge will connect...

But it isn't a Type 4 driver

I don't think a Type 4 driver exists...  Can you use a "proper" database?  (PostgreSQL, Firebird, MySQL, etc)?
0
 
LVL 35

Expert Comment

by:TimYates
ID: 11782381
From: http://mindprod.com/jgloss/jdbc.html

--------------

MS Access is a popular toy database. Even so, you won't find free type 3 or 4 drivers for it. Your options are the rather expensive IDS Server or rmiJDBC. The JDBC-ODBC bridge is your last resort.
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 35

Expert Comment

by:TimYates
ID: 11782385
0
 

Expert Comment

by:elrichal
ID: 11783468
As far as I know you don't need any extra driver, you can connect to a Access database from Java using:

DriverManager.getConnection("jdbc:odbc:MS Access Database;DBQ=" + pathMDB, user, passwd);

Good luck,

elrichal
0
 
LVL 4

Expert Comment

by:JK2429
ID: 11783489
Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC)
>Select MS Access Database
Then fill in the appropriate fields and you have your driver set up for connection.

If you will be using java to connect to MS Access database, you can connect to it this way.   Here is a tutorial which shows how it can be done.
http://home-1.worldonline.nl/~bmc88/java/jdbc/
http://www.javaworld.com/javaworld/javaqa/2000-09/03-qa-0922-access.html
http://www.oreilly.com/catalog/javadata/chapter/ch04.html


Cheers


0
 

Expert Comment

by:elrichal
ID: 11783883
You are rigth JK2429, but with the path I suggest you don't need a ODBC link. That's better if you have to distribute your software.

elrichal
0
 

Expert Comment

by:veerAkula
ID: 11791468
jdbc/odbc bridge is the option available.
0
 
LVL 35

Expert Comment

by:TimYates
ID: 11791693
>  jdbc/odbc bridge is the option available.

like I said ;-)
0
 

Author Comment

by:abbas1982
ID: 12286721
Sorry, every body, but due to some technical problem I couldnt appear. Also the problem was that The user is not allowed to use the ODBC control. So it should be set automatically. Or some ODBC less driver.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
custom annotations 9 38
HashTable highest marks enumeration alternative 9 37
Why my table column Id is not passed to java object? 4 38
Running JavaFX on JDeveloper 12C 1 31
For customizing the look of your lightweight component and making it look opaque like it was made of plastic.  This tip assumes your component to be of rectangular shape and completely opaque.   (CODE)
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …

813 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

10 Experts available now in Live!

Get 1:1 Help Now