Free JDBC Driver for MS Access

Hello.

Is there any free JDBC MS ACCESS driver.

Please reply soon.
abbas1982Asked:
Who is Participating?
 
TimYatesCommented:
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
 
TimYatesCommented:
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
elrichalCommented:
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
 
JK2429Commented:
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
 
elrichalCommented:
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
 
veerAkulaCommented:
jdbc/odbc bridge is the option available.
0
 
TimYatesCommented:
>  jdbc/odbc bridge is the option available.

like I said ;-)
0
 
abbas1982Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.