aspose file tools*
The moose likes Other Java Products and Servers and the fly likes Questions about StarOffice Base Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Questions about StarOffice Base" Watch "Questions about StarOffice Base" New topic
Author

Questions about StarOffice Base

Chris Cingrani
Ranch Hand

Joined: Nov 21, 2000
Posts: 69
How does the StarOffice Base product compare to MS Access (or even SQL)? According to Sun's website, "Active Data Objects (ADO) object interface enables StarOffice Base to front-end Microsoft Access 2000, Oracle, and other SQL databases"
So, I realize it can interface with these other databases, but I am curious to how robust the product is by itself? Does anyone use this as their primary database?
Floyd Jones
Greenhorn

Joined: Dec 13, 2000
Posts: 25
Howdy Chris -
Thanks for THAT can o' worms! I'm tempted to take that and just go fishin'. Or just use the Dr. Evil method and say, "Lemme tell ya a little story 'bout a man named SHHHHH!"
Anyhoo, to get to the guts of your question about
how robust the product is by itself? Does anyone use this as their primary database?
:
You can create databases from scratch in SO 5.2 using two different formats:

  • dBase - For single, non-relational tables (the SO Address Book is in this format)
  • Adabas D - Version 5.2's relational database tool.

  • dBase works great, especially if you just wanna throw stuff in a single table. Adabas D seems to work okay, and if you want to create relational database from scratch in SO, that's what you've got.
    Aside from that, SO offers the following connectivity:

    • StarBase (for connecting to relational databases created in older versions of SO
    • MS Access 97, which does a remarkably good job at reading and displaying Access databases, relations and all (on SO for the Monopoly platform only)
    • Oracle
    • DB2
    • ADO (Monopoly platform only)
    • ODBC
    • JDBC
    • Text (for read-only database rendering of delimited text files)

    • As far as whether or not anyone is using it as their database of choice, I can't say. But I will say this: If you're just doing minor stuff with databases (mail merges, tracking your inventory of buffalo hides, and other low-overhead use), using single dBase tables in SO is really, really cool. But if you're looking to work with really beefy relational databases, I'd stick with a tool for now that's dedicated to that sort of thing.
      And if you're not sure how you're going to use databases, I highly recommend reading "The Database Tirade" on p. 990 of the book.

      ------------------
      author of:
      StarOffice Companion
      Standard CYA*******************************
      All responses to questions posed in this News Group are given on an
      "as is" basis. We believe the solutions or explanations given here are
      correct, but do not guaranty that responses will be complete, without
      error and/or work for all platforms and system configurations.


author of:<BR><A HREF="http://www.amazon.com/exec/obidos/ASIN/0130307033/electricporkchop" TARGET=_blank rel="nofollow">StarOffice Companion</A>
Chris Cingrani
Ranch Hand

Joined: Nov 21, 2000
Posts: 69
Floyd - Thanks for the reply. I am currently using Oracle at work, and I didn't expect StarOffice to offer something more robust than that. However, I did appreciate the explanation of the functionality, as I haven't used StarOffice yet (I don't think my 56K can handle the download!)
If I buy (or win) a copy of your book, does it come with the full version of StarOffice on CD?
[This message has been edited by Chris Cingrani (edited December 20, 2000).]
Floyd Jones
Greenhorn

Joined: Dec 13, 2000
Posts: 25
DOH! You had to go and ask "the question":
If I buy (or win) a copy of your book, does it come with the full version of StarOffice on CD?

Solveig and I (and our agent at Sun Press) fought like the dickens to get the CD included in the book. We nearly had it, but at the last minute the product group asked us not to do it. We never got a clear explanation about that. So no, it doesn't come with the book.
Looking at the download numbers for SO on sun's home page www.sun.com (something like 4 million), I wonder how accurate that is. Lord knows I account for probably half of that trying to download it with my 56K (it even took a while with my new DSL at 50K throughput). So I finally just forked out the $15 or whatever it is and ordered a CD.
------------------
author of:
StarOffice Companion
Standard CYA*******************************
All responses to questions posed in this News Group are given on an
"as is" basis. We believe the solutions or explanations given here are
correct, but do not guaranty that responses will be complete, without
error and/or work for all platforms and system configurations.
Floyd Jones
Greenhorn

Joined: Dec 13, 2000
Posts: 25
Chris -
I checked back on Sun's site, and you're right. The offer for getting an English CD only seems to be gone! That really stinks. But the better news is that I found the following URL where you can order a copy of the 5.2 CD for a grand total (includes shipping) of $1.50!
https://www.justwebit.com/cgi-bin/e/eprodsdb.cgi?9713+24+m
------------------
author of:
StarOffice Companion
Standard CYA*******************************
All responses to questions posed in this News Group are given on an
"as is" basis. We believe the solutions or explanations given here are
correct, but do not guaranty that responses will be complete, without
error and/or work for all platforms and system configurations.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Questions about StarOffice Base