• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

Free JDBC Driver for MS Access

Hello.

Is there any free JDBC MS ACCESS driver.

Please reply soon.
0
abbas1982
Asked:
abbas1982
1 Solution
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now