Solved

Accessing Ms Access database in Linux using Java

Posted on 2006-10-25
4
199 Views
Last Modified: 2010-03-31
I placed an Ms Access database (aaa.mdb) in Linux and tried to access it using Java but to no avail. it came out nullpointerexception in the statement Class.forName("sun.org.....").
Is it possible to access it and do i need a special driver?
0
Comment
Question by:jefcheek
  • 2
4 Comments
 
LVL 14

Expert Comment

by:hoomanv
ID: 17809699
AFAIK MS Access should be there to open and manipulate the data in mdb file
Therefore a windows platform is needed
http://forum.java.sun.com/thread.jspa?threadID=650819
http://database.ittoolbox.com/documents/popular-q-and-a/using-ms-access-database-with-java-2136
0
 

Author Comment

by:jefcheek
ID: 17809830
what u tried to say is that it won't work if the mdb is placed inside Linux platform ??I know it will work in windows as i managed to access it even without the need to install ms access program. but can it work in Linux?
0
 
LVL 14

Expert Comment

by:hoomanv
ID: 17809907
> i managed to access it even without the need to install ms access
I didn't know that
What is you driver class and connection url ?
0
 
LVL 10

Accepted Solution

by:
mbvvsatish earned 50 total points
ID: 17810110
try this post "Microsoft Access Database using Linux and PHP"

http://bryanmills.net:8086/archives/2003/11/microsoft-access-database-using-linux-and-php/
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

For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
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…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:

919 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

22 Experts available now in Live!

Get 1:1 Help Now