Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to access MS-Access(.mdb) file in java program with MAC OS

 
narasimharao konjeti
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai,

I have java application with database MS access(.mdb).This mdb file i can access in windows OS with mdb drivres.
But this java application i want to run on MAC operating sytem.I am not able to access .mdb file. How can i access? is there any mdb drivers to support the MAC OS??? What is the database like Ms-acees in MAC OS.???
I am waiting for reply
pls reply asap.
Thanks and regards.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64631
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hmmm, if I remember correctly (and this knowledge may be out of date) MS Access is not JDBC-compatible and requires the ODBC-JDBC Bridge in order to be accessed from Java. And (again this may be old knowledge) the ODBC-JDBC Bridge is not pure Java, so it may not be able to run under Mac OS.
What I'd do is to find out more about the cross-platform compatibility of the JDBC drivers you are using.
With regards to replacement databases, since OS X is a UNIX platform (unless you are using OS 9, that is) it will run most UNIX databases. I've had PostgreSQL (a favorite of mine) runnning well under OS X, and have heard that MySQL runs without difficulty as well.
If your app is written to be database independent, you should be able to swap out Access for one of these database with little difficulty.
hth,
bear
P.S. Anyone with more current knowledge about MS Access with JDBC should jump in!
[ August 22, 2003: Message edited by: Bear Bibeault ]
 
Amy Phillips
Ranch Hand
Posts: 280
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yeah I do believe you are right about needing the ODBC-JDBC bridge to connect to MS-Access. I am also not confident about an Access DB being database independent, isn't that the whole problem with Access?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic