aspose 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
Register / Login
JavaRanch » Java Forums » Java » Servlets
Reply 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: 14460
    
    7

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?
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Tomcat on Linux and Access on Windows
 
Similar Threads
Survey- What platform do you use to program in Java?
Wondows from Linux
Java in Windows to access Linux server
down load jboss for linux
jar executeable