wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 19649
    
  18

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.
 
Similar Threads
accessing MS.Access from Linux Server.
naive server ip connection question
Connecting WAS/WPS to DB2 database
RMI problem on Linux
How to run xwindows from the Client Machine