This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills and have John Sonmez on-line!
See this thread for details.
The moose likes JDBC and the fly likes How to connect to Ms.Access on Linux Server. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to connect to Ms.Access on Linux Server." Watch "How to connect to Ms.Access on Linux Server." New topic
Author

How to connect to Ms.Access on Linux Server.

Ankita Jha
Ranch Hand

Joined: Sep 15, 2008
Posts: 55
Hello ranchers,
Can any one guide me on how to connect to Access database on linux server.
Any help will be appreciated.



Thanks in advance.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19783
    
  20

Moving to JDBC.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Martijn Verburg
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

I'm assuming your access database is on a windows server and your java application on the Linux server right? In that case you need to read up on the JDBC and/or ODBC/JDBC driver for Access that works with your flavour of Linux/Application Server


Cheers, Martijn - Blog,
Twitter, PCGen, Ikasan, My The Well-Grounded Java Developer book!,
My start-up.
Ankita Jha
Ranch Hand

Joined: Sep 15, 2008
Posts: 55
I'm assuming your access database is on a windows server and your java application on the Linux server right?


This is not the case.My Application as well as database both are on linux server.
Martijn Verburg
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

Sorry I got confused there, thought you were talking about an MS Access Database. What type of Database do you have?

If both are on the same server then you still need to include the JAR file that contains a JDBC driver for your particular type of database. You can then use normal JDBC lookups in order to connect.
jittu goud
Ranch Hand

Joined: Mar 30, 2007
Posts: 46
how can MS access ...run on linux
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to connect to Ms.Access on Linux Server.