• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to connect to Ms.Access on Linux Server.

 
Ankita Jha
Ranch Hand
Posts: 55
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello ranchers,
Can any one guide me on how to connect to Access database on linux server.
Any help will be appreciated.



Thanks in advance.
 
Rob Spoor
Sheriff
Pie
Posts: 20369
44
Chrome Eclipse IDE Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to JDBC.
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm assuming your access database is on a windows server and your java application on the Linux server right? In that case you need to read up on the JDBC and/or ODBC/JDBC driver for Access that works with your flavour of Linux/Application Server
 
Ankita Jha
Ranch Hand
Posts: 55
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm assuming your access database is on a windows server and your java application on the Linux server right?


This is not the case.My Application as well as database both are on linux server.
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry I got confused there, thought you were talking about an MS Access Database. What type of Database do you have?

If both are on the same server then you still need to include the JAR file that contains a JDBC driver for your particular type of database. You can then use normal JDBC lookups in order to connect.
 
jittu goud
Ranch Hand
Posts: 46
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how can MS access ...run on linux
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic