Solved

Free JDBC Driver for MS Access

Posted on 2004-08-12
13
323 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PDFBox - convert image to PDF, PDF resolution 3 117
Starting to learn JAVA, 7 59
bitbucket vs gitbucket 3 57
diffSum example 4 26
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This video teaches viewers about errors in exception handling.

920 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

16 Experts available now in Live!

Get 1:1 Help Now