Solved

Free JDBC Driver for MS Access

Posted on 2004-08-12
13
325 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
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.

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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

Suggested Solutions

Title # Comments Views Activity
numbers ascending pyramid 101 214
What's wrong with this code? 4 28
Problem to Alipay 10 48
Fast way to search item into Java Array (Rhino compatible) 2 31
For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

820 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