?
Solved

Accessing Ms Access database in Linux using Java

Posted on 2006-10-25
4
Medium Priority
?
210 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 150 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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…
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
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:
Suggested Courses
Course of the Month13 days, 20 hours left to enroll

800 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