wood burning stoves 2.0*
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 Android Security Essentials Live Lessons this week in the Android 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: 15959
    
  19

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?
 
Consider Paul's rocket mass heater.
 
subject: Tomcat on Linux and Access on Windows
 
Similar Threads
Wondows from Linux
Survey- What platform do you use to program in Java?
jar executeable
down load jboss for linux
Java in Windows to access Linux server