Arthur Pemberton wrote: Have you checked www.openoffice.org? In any case, I'd like to use your thread (to avoid opening another) since you talk about OOorg and I wanted to ask something about OO.org too... OO.org 1.1.4 is out... Are there any FC2/3 RPMs ready somewhere? If so where? Thanks... Sorry for highjacking your thread...

On Thu, 2005-01-27 at 21:00 -0400, Arthur Pemberton wrote: OpenOffice doesn't really provide a native database program. For simple database applications, OpenOffice.org 1.1 supports dBASE (.dbf) databases without any additional software. OpenOffice also supports MySQL databases natively, so if you have MySQL connected and running, you can use OpenOffice to create databases. You can set up Unix ODBC and then connect to a MySQL database or use the MySQL JDBC drivers. That said, you can create a file-based database right now. 1. Under Tools-->Data Sources right click under the list of data sources, and create a new data source. 2. Select DBase, and then fill in the URL with a file path. Hint: use the Bibliography database URL as an example. 3. Now go to the Tables tab and select new table 4. Edit away It's not very elegant, but it appears to work. You can lace OpenOffice into any database that has a JDBC or UNIX ODBC driver. I'm not quite sure where you place the drivers so that OpenOffice can load them, but I'm sure it's buried in the documentation somewhere. That said, I've been playing with DBDesigner (http://www.fabforce.net/). There appears to be a problem with DBDesigner and MySQL 4 in that it doesn't seem to want to take a password when connecting to a specific database. I haven't tried it via ODBC. Also, the graphics aren't very good since this is written in Delphi (I think). I also use SQuirrel (http://squirrel-sql.sourceforge.net/). I personally think this a great tool for doing SQL queries, although it's not much for developing databases. Hope this helps. ----- /mde/ just my two cents . . . .

Richard S. Crawford wrote: Oh...so that's the problem, I have to wait. I couldn't really figure out when they plan to release a stable with the database component, any idea? A database compontent is an essential part of some high school comsci sylabuses.

On Thu, 2005-01-27 at 17:16 -0800, Richard S. Crawford wrote: FWIW, there was just an article at NewsForge on the OO.org DB: http://software.newsforge.com/article.pl?sid=05/01/25/1758245 HTH, Marc Schwartz

Scot L. Harris wrote: I'm interested in this for the high schools in my country who belive that M$ Office is the end all be all computing. The comsci syllabus here uses an Wordprocessor+spreadshet+database combination. So it would be terribly difficult for me to suggest OO if there's no such database component. I myself have very little need for such.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Kevin Fries wrote: | Arthur Pemberton wrote: | | | I'm interested in this for the high schools in my country who | belive | that M$ Office is the end all be all computing. The comsci | syllabus | here uses an Wordprocessor+spreadshet+database | combination. So it | would be terribly difficult for me to suggest | OO if there's no such | database component. I myself have very | little need for such. | So what you are looking for is something | like Rekall? | | If memory serves me correctly, didn't The Kompany put out a lower | featured GPL'd version of Rekall? For some reason, I want to say | it was added to the KDE project. Does this ring any bells with | anyone? | | If not, at $70.00 per seat (less for volume licenses), the price | beats the pants off M$ Access at approx $100 - $130 per seat. And | if you use a full database back end like Postgre or MySQL, OO.o has | an awesome mail merge feature on the F4 key. OK, sorry for answering my own post, should have done more checking before spouting off. See: http://www.rekallrevealed.org/ It sounds like what you are looking for. Kevin Fries