This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
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


Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
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: 17142
    
  27

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.


An IDE is no substitute for an Intelligent Developer.
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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Tomcat on Linux and Access on Windows
 
It's not a secret anymore!