Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Tomcat on Linux and Access on Windows

 
Mark Leong
Ranch Hand
Posts: 60
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there anyway I count run servlets on Linux and access Access DB residing on a Windows PC?
 
Madhav Lakkapragada
Ranch Hand
Posts: 5040
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Theoritically speaking, you should be able to do this
provided you have the right JDBC Drivers.
regds.
- satya
 
Mark Leong
Ranch Hand
Posts: 60
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 5040
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

i would first start with Sun website and look around JDBC. http://java.sun.com
- satya
 
Tim Holloway
Saloon Keeper
Pie
Posts: 17646
39
Android Eclipse IDE Linux
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Mark Leong
Ranch Hand
Posts: 60
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic