• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

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

 
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Sheriff
Posts: 67753
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Ranch Hand
Posts: 280
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Why is the word "abbreviation" so long? And this ad is so short?
New web page for Paul's Rocket Mass Heaters movies
https://coderanch.com/t/785239/web-page-Paul-Rocket-Mass
reply
    Bookmark Topic Watch Topic
  • New Topic