File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Mac OS and the fly likes How to access MS-Access(.mdb) file in java program with MAC OS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » Mac OS
Bookmark "How to access MS-Access(.mdb) file in java program with MAC OS" Watch "How to access MS-Access(.mdb) file in java program with MAC OS" New topic
Author

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

narasimharao konjeti
Ranch Hand

Joined: Apr 26, 2003
Posts: 130
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.


"Unwise to sweat petty stuff, wise to pet sweaty stuff."
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61010
    
  65

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 ]

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Amy Phillips
Ranch Hand

Joined: Apr 02, 2003
Posts: 280
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?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to access MS-Access(.mdb) file in java program with MAC OS