File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Servlets and the fly likes Tomcat on Linux and Access on Windows Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "Tomcat on Linux and Access on Windows" Watch "Tomcat on Linux and Access on Windows" New topic
Author

Tomcat on Linux and Access on Windows

Mark Leong
Ranch Hand

Joined: Dec 11, 2000
Posts: 60
Is there anyway I count run servlets on Linux and access Access DB residing on a Windows PC?
Madhav Lakkapragada
Ranch Hand

Joined: Jun 03, 2000
Posts: 5040

Theoritically speaking, you should be able to do this
provided you have the right JDBC Drivers.
regds.
- satya

Take a Minute, Donate an Hour, Change a Life
http://www.ashanet.org/workanhour/2006/?r=Javaranch_ML&a=81
Mark Leong
Ranch Hand

Joined: Dec 11, 2000
Posts: 60
Can you point me to the site where I could get the drivers?

I have used jdbc dbc drivers before but they are installed on the m/c where the Access DB is. My problem now is one m/c is using Linux and the other is Windows.
Madhav Lakkapragada
Ranch Hand

Joined: Jun 03, 2000
Posts: 5040

i would first start with Sun website and look around JDBC. http://java.sun.com
- satya
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16061
    
  21

You should note though that Access is too much of a lightweight to do more than experiment with for Internet purposes, though. For serious work you'd be better off putting the data into a MySQL or PostgreSQL database on the Linux machine. These DBMS's can be accessed from the Windows machines using ODBC, etc.


Customer surveys are for companies who didn't pay proper attention to begin with.
Mark Leong
Ranch Hand

Joined: Dec 11, 2000
Posts: 60
My Access DB is really very light - couple of hunderds of records.
Even if I want to transfer the data to Postgres, I would like to know how to access it without running ASP or other related technology on the Assess db m/c.
I could mount the Windows drive to the Linux m/c. But after that how do I setup the ODBC drivers?
 
Don't get me started about those stupid light bulbs.
 
subject: Tomcat on Linux and Access on Windows